Conditional Formatting Based on 2 Date Columns, with or without Helper Column


Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06/29/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06/29/2023 deadline, and I can have a third column as a helper if needed.

Appreciate any help!

Best Answer

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    Answer ✓


    @Eric Law - you are speedy 😊

    Another option would be to us a Sheet Summary field for the Expiration Helper Column - Mtg Date instead of a column in the sheet.

    Flag column formula: =IFERROR(IF([Membership Expiration]@row <= [Expiration Helper Column - Mtg Date]#, 1, 0), "No Date")

    Sheet Summary field (Expiration Helper Column - Mtg Date would equal 6/29/23

    Hope this helps.

    Thanks -Peggy


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!