Update Requests
I would like to have a update request go out when the value of a cell in a column goes bellow the number in a cell in another column in the same row, im wondering if this is possible. I cant find a way to do so. the catch is the numbers will be different for every row so i cant use one specific number which is the only option I can find.
Best Answer
-
I have found a work around using the status ball
Answers
-
I have found a work around using the status ball
-
Hi @LUCA GALLEGO,
You can add a helper column to do the evaluation, and then add the Update Request workflow based off the value of that column.
For instance if you use a checkbox column you could use this formula with your column names:
=IF([Value 1]@row [Value 2]@row, 1, 0)
Then create your workflow to look at the checkbox column value.
"When rows are change"
"When Checkbox value changes to "Checked".
Then you can select Update Request and customize your message.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!