Trying to have a checkbox "check" auto if a date is in the future....

Steve Joyce

If LEASE END is TODAY() then checkbox = 1.....

Andrée Starå

@Steve Joyce

Excellent!

You're more than welcome!

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

Andrée Starå

Hi @Steve Joyce

Try something like this.

=IF([LEASE END]@row > TODAY(); 1)

Did that work?

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!

Steve Joyce

Negative....

mwiggins

=IF([LEASE END]@row>TODAY(),1,0)

Steve Joyce

got it - no semi colon after TODAY(), comma instead - Thanks!!!!!

Andrée Starå

@Steve Joyce

Try this one instead.

=IF([LEASE END]@row > TODAY(), 1)

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Steve Joyce

Yup - That was it!!!!1 Thank You very much

Andrée Starå

@Steve Joyce

Excellent!

You're more than welcome!

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