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

Question

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 Harris
------------------------------

markshnier__you · Answer

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
[email protected]
------------------------------

ciaraharris · Answer

The Best - thanks so much, Mark!!------------------------------Ciara Harris------------------------------

Forum Discussion

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

2 Replies

Related Content

QrewTip: Formula Logic Order

Code Page Formula Button

Formula to calculate hours

GetRecords Formula Help

URL formula -API_RunImport