change cell value to include {{column}} does not work same way as email workflow
I am using a Change Cell workflow to use the same feature of the email workflow of embedding {{column}} into the text.
The same text that works in email workflow does not work in the change cell.
In this example, if the Speed Limit Column is 100 and the Infringe Speed column is 121, the test that is produced should be Exceed speed limit 100km/h, vehicle speed of 121km/h.
I have used this exact text in the Email workflow and it works but it does not in the Change Cell workflow.
Is this a known bug?
It should behave consistently.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Best Answer
-
- You must specify the exact value that you want to input in a cell. At this time, it is not possible to add a formula to a cell, reference the value in another cell, or reference the value in a sheet summary field.
This excerpt is from this help article on change cell automations:
https://help.smartsheet.com/articles/2482299-change-cell-value-in-an-automated-workflow
Answers
-
- You must specify the exact value that you want to input in a cell. At this time, it is not possible to add a formula to a cell, reference the value in another cell, or reference the value in a sheet summary field.
This excerpt is from this help article on change cell automations:
https://help.smartsheet.com/articles/2482299-change-cell-value-in-an-automated-workflow
-
@Mike TV Thanks for your response
I have updated my question to include the actual Change Cell text.
It appears that given this is referencing another value of another cell that it is not supported.
This should work in the same way as it does in the Email workflow.
@Genevieve P. are there plans to address this?.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
-
Hi @Frank Falco
I hope you're well and safe!
Great idea! That would be a great addition to Smartsheet features.
Please submit an Enhancement Request when you have a moment.
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!