Formula to check a box when date entered + 2 days

edited 12/09/19

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!

«1

• ✭✭✭✭✭✭

Try removing the plus sign.

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

Thanks!

• ✭✭✭✭✭✭

Try this...

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

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

• ✭✭✭✭✭✭

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)

• ✭✭✭✭✭✭

Thanks for jumping in Paul.

• ✭✭✭✭✭✭
• THANK YOU! This worked great!

• ✭✭✭✭✭✭
• ✭✭✭✭✭✭
edited 01/30/20

@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...

• ✭✭✭✭✭✭

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

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.

• ✭✭✭✭✭✭

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)

• ✭✭✭✭✭✭

@Paul Newcome Good catch! 👍️

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.

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!