5

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

Andree_Stara

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