IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow Sta

Molly Morton

Looking for formula help.

I have a comments column that I want to make sure is never more than 5 days old.

If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date for which it was updated on.

Is this possible?

Thanks

Molly Morton

Paul Newcome

The easiest way to go about this would be to include a date type column that can have the date updated manually entered.

Otherwise there may be a way to accomplish this using the Copy Row automation and cross sheet references, but that could definitely get a little tricky.

You could also look into Zapier as an option to input the date when a specific field is updated, but I am not the best one to speak on that option.

Andrée Starå

Hi Molly,

The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD