Automation for Column Help
I am interested in using the automation for our inventory. Currently we have our sheet set up with two columns Current Stock and Re Order stock. We are trying to have a workflow where if column Current re stock is equal to Re Order stock it send an email that its time to reorder this specific item. We are running into an issue with triggers where its asking for a specific number but we anticipate all the values being different.
Any guidance with this would be helpful!
Best Answer
-
If you have space to add a column, you could use a "helper" column that triggers the automation instead. For example, a column with a formula subtracting one column from the other: =[Current Stock]@row - [Re Order stock]@row
Then make an automation to send an email when that helper column changes to 0.
Or to be fancier, make a column with an IF formula. For example: =If([Current Stock]@row = [Re Order stock]@row, "RE-ORDER", "no action needed")
And then set the automation to send an email when that helper row changes to the RE-ORDER message.
Answers
-
If you have space to add a column, you could use a "helper" column that triggers the automation instead. For example, a column with a formula subtracting one column from the other: =[Current Stock]@row - [Re Order stock]@row
Then make an automation to send an email when that helper column changes to 0.
Or to be fancier, make a column with an IF formula. For example: =If([Current Stock]@row = [Re Order stock]@row, "RE-ORDER", "no action needed")
And then set the automation to send an email when that helper row changes to the RE-ORDER message.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives