stock amount update with order fulfilled

Yuval

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

Anjanesh Vaidya

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.☺️

Anjanesh Vaidya

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.☺️

Yuval

Anjanesh,

many thanks, working just great

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