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

Answered - Pending Review

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?


Molly Morton

Popular Tags:


  • Paul NewcomePaul 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å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!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.