Cross-sheet formula with checkbox
Hello all,
I am trying to create a cross-sheet summary metrics sheet that counts data based on Status and whether a box is checked. If the "Project?" column check box is checked AND the Status is (for example) In Progress, I'd like this formula to count the number of instances. No matter what I try for the checkbox (true, 1, checked), I get UNPARSEABLE. Is this formula possible?
Thank you!
Best Answers
-
Hi @Tamara Cook
There's some remaining brackets in your formula that are creating the #UNPARSEABLE. Just remove and you'll be fine:
=COUNTIFS({BIM Project}, 1, {BIM Status}, "In Progress")
Hope it helped!
-
@David Joyeuse that worked perfectly. What a silly mistake on my part. Thank you so much!
Answers
-
Hi @Tamara Cook
There's some remaining brackets in your formula that are creating the #UNPARSEABLE. Just remove and you'll be fine:
=COUNTIFS({BIM Project}, 1, {BIM Status}, "In Progress")
Hope it helped!
-
@David Joyeuse that worked perfectly. What a silly mistake on my part. Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!