Building a workflow to trigger on a comparison of two columns
I am building a workflow where I want to trigger an alert when the value in one column is less then the value in another column. How do I do that?
Best Answer
-
Hi Chuck,
You could add a helper column that contains trigger.
Add a "Checkbox" type column. Then insert your formula into the cell. The following formula assumes the cell you are using is in the 1st row, Checkbox column.
=IF([Column1]1<[Column2]1, "1", "0")
This formula would check the box if the Column1 value is less than the Column2 value.
To make the formula more efficient for the full sheet, use the following formula in the helper column.
=IF([Column1]@row<[Column2]@row, "1", "0")
Then you can setup your workflow automation off the checkbox column.
Hope this helps,
Connor
Connor Hartford
Answers
-
Hi Chuck,
You could add a helper column that contains trigger.
Add a "Checkbox" type column. Then insert your formula into the cell. The following formula assumes the cell you are using is in the 1st row, Checkbox column.
=IF([Column1]1<[Column2]1, "1", "0")
This formula would check the box if the Column1 value is less than the Column2 value.
To make the formula more efficient for the full sheet, use the following formula in the helper column.
=IF([Column1]@row<[Column2]@row, "1", "0")
Then you can setup your workflow automation off the checkbox column.
Hope this helps,
Connor
Connor Hartford
-
Connor - thanks for this solution - it works like a champ!
Chuck
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives