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

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!
Answers
-
@PattiL Checkboxes don't take text as an argument. You need to use a value of 1 for "checked" and 0 for "unchecked".
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
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
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. π
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!