Reference Another Row in a Workflow

Hi,


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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!