How do I count how many rows where today falls between the Start Date and the End Date?

I'm trying to count how many rows of the sheet fall between the Start Date and the End date.

I've tried various formulas, including ones that I've found online. This is the one I'm currently trying and its coming up as #UNPARSEABLE. Can someone tell me what I'm doing wrong? I'd like to use this formula in a summary sheet.

=COUNTIFS([Start Date], @row <=TODAY(), [End Date], @row >=TODAY())

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!