I need to set up an update request for when a box has been checked for 2 weeks

Crystal Crews

I have a two condition update I'm having issues with:

If box is unchecked x2 weeks and no date is in the date column, send an update request.

Can someone help me do this?

Bassam Khalil

Hi @Crystal Crews 

Hope you are fine, i created a sample sheet to explain the solution.

1- insert Auto-number/system column ( created date )

2- create date type column ( Past Date ) with the following formula =TODAY() - 14 to identify the 2x week date from today. convert the formula to column formula

3- create text/number type column ( Check Date ) with the following formula =Created@row - [Past Date]@row to check how many day pass since you create the record.

4- create automation to trigger update request as the following in screen shot.

Andrée Starå

Hi @Crystal Crews

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @Crystal Crews 

Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!