I’d like to have a column which will display if it’s time for a page to be updated. It should look at my “Last Updated” column date and if today’s date is less than 1 month from then it from then it would say “Current”, if more than 1 month it would say “Needs Update”, if more than 2 months it would say “Update Now”. Any thoughts? Thanks!
Yes, exactly. Now let’s say I have three options though, how would I do this?
Last Update is less than 30 days would be “Current”
Last Update is between 30 days and 60 days would be “Needs Refresh”
Last Update is more than 60 days days would be “Update Now”
Great! Going to bother you with one more thing. I’d like to color records based on my Days Since Update field. Could I do that? For example if under 30 days, green. If between 31 and 60 days, orange. And anything greater than 61 days, red.
I definitely have the premium version, but I did something and now I can’t see how to add back that feature. Is there no way to do that? Make it so the record turn green, orange or red based on a certain number of “Days Since Last Update”?