If/then question with color formatting

This is what I am trying to accomplish. Is there a way through conditional formatting or any other options

  • If [Report Submission Date] is greater than [Report Due-10] then Report Past Due Flag should be RED
  • If [Report Due Date-10] is in the past AND [Report Submission Date] is blank, then Report Past Due Flag should be BLUE


  • MCorbin
    MCorbin Overachievers Alumni

    You can format your "Report Past Due" field as a Symbol column type. Based on your colors, I selected the 4 color balls symbol type:

    Which gave me these results:

    Using this formula:

    =IF([Report Submission Date]@row > [Report Due-10]@row, "Red", IF(AND([Report Due-10]@row < TODAY(), ISBLANK([Report Submission Date]@row)), "Blue"))

  • MCorbin
    MCorbin Overachievers Alumni

    You could also use the "color" column as a helper column, and set conditional formatting to format the Report Submission date column based on whether the Color column says "Red" or "Blue"

  • Cyndi
    Cyndi ✭✭

    Thank you so much! I like using the dots it's more eye catching.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!