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

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

Answers

  • Paul Newcome
    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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • 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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!