#UNPARSEABLE using COUNTIF and cross-sheet Reference
This feels like a dumb question.
I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue.
The formula is as follows:
=COUNTIF({Team SCRUM: Communications STATUS Column}Status:Status, "To do")
Any pointers?
Best Answer
-
It looks like you have the column listed twice... once in the {cross sheet} range, and then again as an in-sheet column reference of Status:Status.
Try just having the {cross sheet} and the "Criteria", like so:
=COUNTIF({Team SCRUM: Communications STATUS Column}, "To do")
Let me know if that worked for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
It looks like you have the column listed twice... once in the {cross sheet} range, and then again as an in-sheet column reference of Status:Status.
Try just having the {cross sheet} and the "Criteria", like so:
=COUNTIF({Team SCRUM: Communications STATUS Column}, "To do")
Let me know if that worked for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
-
I'm so glad to hear it! I hope you have a good weekend. 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!