Actual date against Original Date Conditional Formatting

Nancy Pet
Nancy Pet ✭✭
edited 01/06/23 in Formulas and Functions

Q: What is conditional formatting to have Actual: WB Completed date match up against Workbook completed date? Then shade it red if late, no font change if before or on that date

See picture for visuals and thank you in advance for your time.


  • Samuel Mueller
    Samuel Mueller Overachievers
    edited 01/06/23

    @Nancy Pet you are probably going to need a helper column.

    Helper column would have a column formula something like

    =IF([Actual: WB Completed]@row >= [Workbook completed]@row, 1 ,0)

    Then, conditional formatting will be if helpercolumn = 1, shade red. helper column would be the column you select in the conditional formatting box, criteria will be equal to 1, and then you would apply the format to the column you want to show to format.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!