Color coding report based on Date Modified
Hi all! I'm trying my hand at color-coding a report based on any records updated in the past 7 days. I found a few similar threads/tried to emulate the formulas, but it's giving me guff because Date ...
Forum Discussion
Ok - no pipelines experience yet. Here's an idea I'm trying.
New field - Formula Date - and then color code report based on whether that's changed in the past 7 days.
My not-quite-working new formula:
If(Changed([Present Status Brief Detail])>= Today-Days(7), "")
Error Detail:
On "Changed" function - "The number of arguments supplie ddo not meet the requirements of the function Case. The function is defined to be If (Boolean condition1, result1, ..., else-result
Bonus Wishes:
It would be really awesome if I can actually tie this to a specific weekday -- if that field has been updated since last Wednesday. This way, when we're writing our quick team notes, we can skim whole reports of statuses, and the recently-updated statuses will stand out.
Thank you, Mark!
MarkShnier__You
Qrew Legend
Qrew LegendThere is no function called "Changed", so you can't just invent a function which don't exists. Can you you telll me if you are using Legacy Style forms or New style forms and also if all edits will be on forms as opposed to users using Grid Edit. There may be a simple way to trap the date a certain field was changed if you happen to be using Legacy Forms..