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

Dan Elgin
Dan Elgin
edited 12/09/19 in Archived 2015 Posts

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

Tags:

Comments

This discussion has been closed.