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

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    edited 03/13/24 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

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    edited 03/13/24 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⬆️

  • Yuval
    Yuval ✭✭✭

    Anjanesh,

    many thanks, working just great

    Yuval😀

  • Yuval
    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!