Can Automation Workflow update a column with information that is populated in another column
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.
Here is what the field shows in the sheet
Any suggestions on how I can get this to work?
Best 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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Dianne
I hope you're well and safe!
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!