Flag by Last Modified Date Formula

Flag by Last Modified Date Formula

Hi,

I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days).

Right now I have a flag column and a hidden modified date column.

Any help with the formula please?

Thank you!

Jared

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Jared,

    Try something like this.

    =IF([email protected] >= TODAY(-3); 1)

    The same version but with the below changes for your and others convenience.

    =IF([email protected] >= TODAY(-3), 1)

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    Hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree,

    Thank you for the reply, the formula is giving me an error of #CIRCULAR REFERENCE

    I'm in US, but tried both semicolon and comma but same error on both.

    Any ideas?

     

  • The column is actually named "last modify" but when i change "Modifed" in the formula to [Last Modify] i then get an #UNPARSABLE error.

  • Got it! Your formula was correct, I had a typo! 

     

    Thank you so much!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Excellent!

    Happy to help!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.