Using a checkbox in formula

kmorsesmartsheet

Hello All,

My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below:

=IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK")

I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered column would work as well.

Any ideas appreciated on how to make this work - Thank you.

Nathaniel Adamian

You can do this with a nested IF.

=IF([Stock Quantity]32 >= [Reorder Level]32, "OK", IF([ON ORDER]32, "ORDERED", "REORDER NEEDED"))