Formula to check a box when date entered + 2 days

dplunkett79331

Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. 

For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. 

This is the formula that I have been trying without success...

=IF([Finish Step]3 >= TODAY(+2), 1, 0)

 

Thank you!

Mike Wilday

Try removing the plus sign. 

dplunkett79331

That didn't work. Also tried DAY vs TODAY and neither worked. Seems like there should be some way to do this.

Thanks!

 

Paul Newcome

Try this...

 

=IF(TODAY() >= [Finish Step]@row+ 2, 1, 0)

dplunkett79331

That does result in a checked box. However, it checks boxes even if there is no date in the Finish Step column...

 

Paul Newcome

That's because TODAY will always be greater than a blank cell. Adding this in should fix that...

 

=IF(AND(ISDATE([Finish Step]@row), TODAY() >= [Finish Step]@row+ 2), 1, 0)

Mike Wilday

Thanks for jumping in Paul.

Paul Newcome

Sure thing! 

dplunkett79331

THANK YOU! This worked great!

 

Paul Newcome

Happy to help! 

Peggy Parchert

@Paul Newcome - Is it possible to use a formula if you wanted to check a box if the date was equal to or greater than 10/22/2019? I can't seem to modify the above formula to make it work...

Andrée Starå

Hi @Peggy P,

Try something like this.

=IF(ISDATE(Date@row); IF(Date@row <= DATE(2019; 10; 22); 1))

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

=IF(ISDATE(Date@row), IF(Date@row <= DATE(2019, 10, 22), 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?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

@Peggy P @Andrée Starå

You're going to want to flip the symbol from Less than to Greater than. Also since we are looking for Greater Than, we don't need to include the ISDATE portion either.

=IF(Date@row >= DATE(2019, 10, 22), 1)

Andrée Starå

@Paul Newcome Good catch! 👍️

Paul Newcome

@Andrée Starå Thanks. I do that to myself pretty regularly. Haha

Peggy Parchert

@Andrée Starå @Paul Newcome - That worked! Thank you very much!