Trying to use COUNTIFS with checkboxs
I have been trying to build this from the ground up to try and figure out what I am doing wrong. This seems like it should be easy, but the formula returns "Unparsable".
My formula is: =COUNTIFS([Task Name]:[Task Name], "SMB", [Done:Done], 1)
In english, this should mean if a task name is equal to SMB and the done checkbox is checked, please count.
If I do a single action, it works just fine:
=COUNTIF([Task Name]:[Task Name], "SMB")
Please help me!
Help Article Resources
Check out the Formula Handbook template!