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

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!