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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!