Past Due date

I am trying to figure out a way to high light the row, when the date requested has passed it 7-day return. Even if date receive is blank, I want it to highlight the row because the current has been more then 7 days. Currently on the duration we have it counting once we enter the date receive. I don't have it highlight when it's been more then 7 days.



Answers

  • Monique Odom-Stearn
    Monique Odom-Stearn ✭✭✭✭✭✭

    Hello @Christina v,

    I would suggest creating a helper column with a formula that will tell you how many days have passed, and then you can set up a Conditional Formatting rule based on that column.

    For example: You could use the below formula, and then set a formatting rule that will highlight the row yellow if the helper column is greater than 7.

    =TODAY() - [Date Requested]@row

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom-Stearn

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!