Formula to drive checkbox if today is between the start and end dates

PattiL

Hi All!

I've looked at prior posts on this topic and have followed the formula advice, but I continue to get an error. Here is the formula I am using.

=IF(AND(TODAY() <= [Reporting End Date]@row, TODAY() >= [Reporting Start Date]@row, "Checkbox", ""))

I'm getting an Incorrect Argument error. Help. Thanks!

Darren Mullen

@PattiL Checkboxes don't take text as an argument. You need to use a value of 1 for "checked" and 0 for "unchecked".

Frank S.

Hello @PattiL

Let me know if this works for you:

=IF(AND(TODAY() <= [Reporting End Date]@row, TODAY() >= [Reporting Start Date]@row), 1,0)

Have a great day.

Thanks,

Frank