conditional formatting between 2 columns, same row

7eaven
7eaven
edited 12/09/19 in Formulas and Functions

is there an ability to set a conditional format based on two columns in the same row:

completed (column) date is later than the due (column) date – the cell turns red

completed date entered is before (or after) today's date

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Yes, there is! Thought its kind of hidden. After you set up a conditional formatting you have to click on the arrow to the left of the condition and add another condition. See Screenshot. 

    addcondition.jpg

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!