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.
Solved! Go to Solution.
Hi @marlylove
Try this. 2 issues:
Perfect, thank you!