Flag by Last Modified Date Formula

Actual Goodfella

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

Andrée Starå

Hi Jared,

Try something like this.

=IF(Modified@row >= TODAY(-3); 1)

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

=IF(Modified@row >= 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

Actual Goodfella

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?

 

Actual Goodfella

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

Actual Goodfella

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

 

Thank you so much!

Andrée Starå

Excellent!

Happy to help!