check box if date is 90 days prior to today

TracyM

Hi!

I'm trying to have a box checked if the Due Date is 90 days out. I seem to have that part right

=IF([RR Due Date]@row <= TODAY() + 90, 1, 0)

But it's checking all boxes if they are blank. What can I add to the formula to ignore boxes that are blank?

Thanks so much!

TracyM

Nevermind! I actually figured it out! But couldn't figure out how to delete the post

Andrée Starå

Hi @TracyM

I hope you're well and safe!

Excellent!

Glad you got it working!

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!