Count if referencing other sheet with checkbox in criteria
Trying to count the number of projects where status = High Priority List View and the Delivery box is checked off. Sheet is already reference but can not get formula here
Answers
-
I don't know if you need the "AND" formula in this instance because COUNTIFS already looks at all listed criteria. Also, the first reference doesn't look right. Are you getting an error when you enter it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!