Formulas within conditional formatting?

Lindsey.C
Lindsey.C ✭✭
in Formulas and Functions

I believe this must be possible, right? I have two column 2 my on hand amount and column 4 my par. I want the row to highlight red if the on hand amount is less than the par. Tried to use @row within the conditional formatting but it seems only be highlighting when the on hand amount is less than 1 not less than the par column.

Par@row.png


Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓

    I don't believe this is possible without using a helper column to determine if the On Hand amount is less than PAR. This could be a Yes/No value, then use this column to set the conditional formatting.

    · Share on FacebookShare on Twitter

Answers

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓

    I don't believe this is possible without using a helper column to determine if the On Hand amount is less than PAR. This could be a Yes/No value, then use this column to set the conditional formatting.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!