Action : change cell value
Hi Community,
I feel like this is simple question, but I can make it happen.
If I want to using change cell value in automation workflows, can I change the cell value by using formula?
Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below)
Besides, can it make the value show as parent value + children value? Like the pics show
I want to change the cell "to sam" to become "HBD to sam".
Any help would be amazing! Thanks for any reply!!!
Bosen
Best Answer
-
Unfortunately, you cannot add a formula to Automation workflows.
You can however create an additional column which you can keep hidden if you prefer.
That column can capture the parent and same row data and concatenate them together.
Use this formula, and turn it into a column formula:
=PARENT([Task Name]@row) + " - " + [Task Name]@row
Then you can reference that column for your alerts and/or update requests.
Hope that helps!
BRgds,
-Ray
Answers
-
Hi Bosen,
can you share more information on the main reason why you want to do so with a automation?
What's your final goal, overall?
There might be simpler way to do so.
Best
Davide -
Hi David, thanks for reply!!
I set up a function to send an alert email to task owners and the project manager before the deadline. Instead of displaying the entire sheet, I only show rows that are nearing the deadline. However, some rows don’t display the task name because they are under a parent task. As a result, the email only shows the description(task name is blank), which may confuse the manager about which meeting needs a time confirmation.(like the pics bleow)
Due to this situation, I want to create a function that fills blank cells with the parent task's value or replaces them with 'Parent Task + Current Value' to make the meaning clearer.
That's why I want to change cell values in the automation workflow. However, when I enter the function in the space in workflow, it doesn't run and instead adds a ' at the beginning.
Thanks again for your reply!!
Best
Bosen
-
Unfortunately, you cannot add a formula to Automation workflows.
You can however create an additional column which you can keep hidden if you prefer.
That column can capture the parent and same row data and concatenate them together.
Use this formula, and turn it into a column formula:
=PARENT([Task Name]@row) + " - " + [Task Name]@row
Then you can reference that column for your alerts and/or update requests.
Hope that helps!
BRgds,
-Ray
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!