stock amount update with order fulfilled
Hello Community
I'm building stock management smartsheet, pls. see below simple example
I'm looking formula to automate the process:
I want to have one single entry in "supply to stock date" column: and when I enter "supply to stock date", I want the "order status" to be changed from "in order" to "supplied to stock" and "amount to order" value will move to "amount supplied to stock" cell
thanks in advance
Yuval
Best Answer
-
Hi Yuval,
You can try the following formula in "order status" column.
=IF(NOT(ISBLANK([supply to stock date]@row)), "supplied to stock", "in order")
and, below formula in "amount supplied to stock".
=IF([order status]@row = "supplied to stock", [amount to order]@row)
I hope it will help.☺️
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
Answers
-
Hi Yuval,
You can try the following formula in "order status" column.
=IF(NOT(ISBLANK([supply to stock date]@row)), "supplied to stock", "in order")
and, below formula in "amount supplied to stock".
=IF([order status]@row = "supplied to stock", [amount to order]@row)
I hope it will help.☺️
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
-
Anjanesh,
many thanks, working just great
Yuval😀
-
Just one more request Anjanesh,
in this formula that you proposed =IF(NOT(ISBLANK([supply to stock date]@row)), "supplied to stock", "in order")
when no date stated in "supply to stock date" column cell, I need the "order status" cell to be empty.
Is it possible?
thanks
Yuval
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!