Can Automation Workflow update a column with information that is populated in another column

Dianne
Dianne ✭✭
in Formulas and Functions

We have a column called "Case (Internal Only)" that people clear out when the Status becomes Cancelled. I've tried to get the users to stop doing this but it keeps happening. I'd like to have the information currently populated in this column added to a new column that will be locked and hidden, preventing users from changing it.

I created a rule that uses the mail merge technique, putting the column name with the data I want to load in the double curly brackets {{Case (Internal Only)}}. Unfortunately, this didn't work, the field loads with {{Case (Internal Only)}}.

Here is the rule I created.

image.png


Here is what the field shows in the sheet

image.png

Any suggestions on how I can get this to work?

· Share on FacebookShare on Twitter

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Dianne

    Placeholders {{like this}} are specific only to the values that appear in an email automation. Currently Change Cell workflows need you to identify the exact value you want input into the cell, which is why you see the text {{Case (Internal Only)}}.

    If you need this value "stamped" into another column, I agree with @Andrée Starå's solution above: you would need to copy the data to another, hidden sheet so that it's stored somewhere else in a static fashion. Then you can use a formula to populate your helper column.

    Please also provide the Product team with your feedback and use-case by filling in this form, here!

    Thanks,

    Genevieve

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!