RachelMiller
10 months agoQrew Cadet
Color coding formula based on another formula field
I have a formula rich text field called Last Opened Date with the following formula to trim a logged field so it only pulls out the date:
Trim(Right([*Vista Last Opened Date (Log)],10))
In my report, I want to color code a field called Report Name if the date in the Last Opened Date field is more than 120 days before today. Can you please tell me what formula to use for this? I've tried several and nothing has worked.
Thank You,
Rachel Miller
------------------------------
Rachel Miller
------------------------------