Cross-sheet formula with checkbox

Tamara Cook

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!

David Joyeuse

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!

Tamara Cook

@David Joyeuse that worked perfectly. What a silly mistake on my part. Thank you so much!

David Joyeuse

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!

Tamara Cook

@David Joyeuse that worked perfectly. What a silly mistake on my part. Thank you so much!