Why is my formula #UNPARSEABLE
Hoping someone can help... I am trying to get a count of projects opened and closed based on week number and year. Range two below is the year column in another sheet (the column I'm starting with is 2022, but I will be expanding through 2026 once the formula works). Range 1 referenced below is the week number, as calculated on the 'created date' on my other sheet.
Thanks in advance!
=COUNTIFS({PMO  Task / Project Log Range 2}, =2022, [{PMO  Task / Project Log Range 1}, =[Week Number]@row])
Best Answer

Assuming the values in log range 2 are numbers (if not, then use "2022")
=COUNTIFS({PMO  Task / Project Log Range 2}, 2022, {PMO  Task / Project Log Range 1}, [Week Number]@row)
Answers

I should have noted that each individual piece of the formula works  it is the combination of the two that is not working...

Assuming the values in log range 2 are numbers (if not, then use "2022")
=COUNTIFS({PMO  Task / Project Log Range 2}, 2022, {PMO  Task / Project Log Range 1}, [Week Number]@row)

thank you @Sameer Karkhanis ! that worked  I didnt realize the nuances with the second criterion. thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!