Formula help.

This discussion was created from comments split from: Count if Date Column has any dates older than 7 days.

Answers

  • How would I change this formula if I want to apply conditional formatting to a "Date Needed" column. I want to highlight the date needed column if it is less than 7 days from the day it was requested in the "Request Date" column. I tried this and it didn't work. =IF([Date Needed]@row < ([Request Date]@row, (-7), "Yes")

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    Try:

    =IF(NETDAYS([Date Needed]@row, [Date Requested]@row) < 7, "Yes")

    And play around with what works best, with NETWORKDAYS vs NETDAYS. Or to use your original syntax, it could be something like:

    =IF([Request Date]@row > [Date Needed]@row - 7, "Yes")

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!