Cross Reference Countif Formula is giving Unparsable Error.

I am hoping someone can help with Countifs formula referencing another sheet.

The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31))

However, when I modify on another sheet to read as what is listed below I am getting an Unparsable error. Can anyone see any issues?

=COUNTIFS({2021 Resolved Dates},[Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1),{2021 Resolved Dates},[Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!