How can I color tasks in a report based on how long it's been since they were updated?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I'd like to highlight fields in my report if the last modified time stamp is older than two hours.  


So basically, I guess i'm asking if there is a way I can have it look at the last modified field, extract the time, compare it to the current time, and highlight the row if it's over two hours since the last update.

Photo of Christopher

Christopher

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,708 Points 50k badge 2x thumb
Well you are in luck.  It's easy.

Go to the row colorization box on any Table type report, and use this formula.

If(now() -[Date Modified] > hours(2), "yellow")
Photo of Christopher

Christopher

  • 0 Points
Thank you so much, I was way over complicating it in my attempts.  You're a scholar and a gentleman.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,708 Points 50k badge 2x thumb
:). Glad you got it working.