Forum Discussion

CiaraHarris's avatar
CiaraHarris
Qrew Member
5 years ago

Formula to highlight records on a report that have been modified/updated in the last 7 days

I have a running progress report to display request updates, but want to highlight the requests that have been updated in the last 7 days using color coding. ------------------------------ Ciara H...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Hi Ciara, (just got off a call w/ Elise)

np

Use a formula like this to do row colourization on a table report.

IF(ToDate([Date Modified]) >= Today() - Days (7), "yellow")



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • CiaraHarris's avatar
    CiaraHarris
    Qrew Member
    5 years ago
    The Best - thanks so much, Mark!!

    ------------------------------
    Ciara Harris
    ------------------------------