Automations using Conditions
Hello everyone. I am trying to create a useful automation for an inventory sheet. On the Sheet I have columns "Qty on Order" and "Qty Rec'd". I am trying to create an automation that will alert me if Qty Rec'd is less than Qty on order. How would I go about that?
If I set a condition "Qty rec'd is 'less than'", it wants me to enter a quantity instead of less than Qty on order.
Any ideas?
Best Answer
-
Ha, good catch, if blank is not considered less. then I would put an IF statement around the whole thing. With this formula, I made the assumption that zero and negatives are legitimate possibilities. If not, you can use <> or '>' with a number.
=IF(ISNUMBER([Qty Rec'd]@row), IF([Qty Rec'd]@row < [Qty on Order]@row, 1, 0))
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Answers
-
This is just one way to consider. I like to use a check box column with a column formula to keep it safe from accidental use.
Create a check box column. Insert this formula =IF([Qty Rec'd]@row < [Qty on Order]@row, 1, 0)
Then your automation would just be using the If Rec'd Less is checked condition to see if the condition is true and then perform the automation you wan.t
I hope that helps.
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
-
I love this however... it automatically checks it if the Qty Rec'd is blank. Am I doing something wrong?
-
Ha, good catch, if blank is not considered less. then I would put an IF statement around the whole thing. With this formula, I made the assumption that zero and negatives are legitimate possibilities. If not, you can use <> or '>' with a number.
=IF(ISNUMBER([Qty Rec'd]@row), IF([Qty Rec'd]@row < [Qty on Order]@row, 1, 0))
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
-
This worked perfectly!!!! Thank you!
-
My pleasure!
Thank you,
Kevin
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!