Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Need Help with Formula
Hi All,
I am trying to do a simple formula, but can't seem to get it to work. I'm not an expert in either Excel or SS, so forgive me if this is terribly easy.
I have two columns - one titled "Stock Quantity" and the other "Reorder Point." I would like a formula to evaluate whether the stock quantity is less than or equal to the reorder point. If so, I'd like the stock quantity cell to change color.
Any help is appreciated! Thanks in advance.
Dan
Comments
-
Hi Dan,
Make a new column of type checkbox. It's formula should be:
=if([Stock Quantity]1<[Reorder Point]1, 1, 0)
Make a new conditional formatting rule to do whatever you want it to do, when a cell in that column is checked.
This type of question can be self-served in the help center, next time.
http://help.smartsheet.com/customer/portal/articles/775363-using-formulas
https://www.smartsheet.com/solutions/smartsheet-formula-examples
John
