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
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives