Check Box Advances Due Date to Next Month

Andrée Starå

Hi @Stacey Dorn

The third-party service, Zapier, could be an excellent option for this scenario.

Is that an option for you?

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!

Stacey Dorn

Thank you for the suggestion, Andree. I appreciate all ideas! Unfortunately, due to COVID and cash flow, I hesitate to suggest another app to my company!

Andrée Starå

@Stacey Dorn

You're more than welcome!

You can always start with the free plan and see if that works.

Let me know if you have any questions!

✅Remember! 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!

Paul Newcome

I feel like maybe we were over complicating this here...

Do I see a [Completed On] date type column in your screenshot? If I am looking at it correctly, it looks like that is manually entered to record the date the box is checked?

If that is correct, why don't we just do something like...

=IFERROR(DATE(YEAR([Completed On]@row), MONTH([Completed On]@row) + 1, 15), DATE(YEAR([Completed On]@row) + 1, 1, 15))

Stacey Dorn

Hey, I think that worked! Thank you for taking the time to help me!