Formula error

[marlylove]

I have a workflow where every line (transaction) needs a unique ID in the form of T1, T2, T3, etc. I used the Create New Column tool which works to number my lines, however now I need to add the "T" before the number.  I have tried using a formula tool to add the T to the line number but it's bringing back "-1" on every line or "0" depending on the format. Can someone help? I have added an example workflow.

[Luke_C · Accepted solution]

Hi @marlylove 

Try this. 2 issues:

1. Needed to change the field to a string rather than numeric
2. '&&' is not the proper syntax for this. + should be used to combine strings. 

[marlylove]

Perfect, thank you!