Comparing Columns

Jackie Callahan

Hi,

I feel like there has to be a simple way to do this and I'm just missing it.

I have an inventory report in Smartsheet. One column is the available quantity and another column is the reorder point. Is there a way to highlight the available quantity if it is below the reorder quantity?

Thank you!

Mark Cronk

Hi Jackie,

Add a checkbox column [reorder] with the column formula:

=if([reorder point]@row>=[available quantity]@row, 1, 0)

Then create a conditional formatting rule to highlight the available quantity if [reorder] is checked.

Work?

Mark