Reference Another Row in a Workflow
I have built a workflow that triggers on a specific date then creates a new row automatically (using a method I've outlined in a different post on here) I would like to reference a value in the first row (or even in the second row since it starts as a perfect copy) to append the word "Test" onto the end of the original TaskName.
So on the date that triggers this event we have:
Row1: w/ TaskName = "Create Loading Bar"
I automatically create a Row2
Row2: w/ TaskName = "Create Loading Bar"
Now what I would like to do is have Row2 look at Row1 read the TaskName and then append the word "Test" to the end. In a formula this would look like:
==[Row]1 + " Test"
Unfortunately if I try to write this formula in a workflow it automatically adds a " ' " to the front so it looks like:
'==[Row]1 + " Test"
And therefore will not run the formula and will display the text " '==[Row]1 + " Test" "
Anyone know how to implement this without having to manually change anything?
Help Article Resources
Check out the Formula Handbook template!