Comparing Columns

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!

Tags:

Answers

  • Mark Cronk
    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!