Hello,
I've searched and was not able to find this exactly, and looking over the formula guides I still am not sure how to do this. I am trying to set up a summary field in the sheet summary that looks at the values of two columns and validates both are present to count the field.
Here is the best I could do to try to get it, but it tells me it is unparseable:
=COUNTIF(AND((Risk:Risk, "Not Scheduled"), ([Client Facing]:[Client Facing], ISBOOLEAN(Done1))))
I am trying to look at the values of a single dropdown column RISK and the checkbox column CLIENT FACING and only count the value for each row if:
- value in RISK column = "Not Scheduled"
- CLIENT FACING is a checked checkbox
From what I can tell, the COUNTIF is still looking for the criterion, but since it is an AND statement, the criterion is within the AND grouping.
Where am I going wrong with this?
Thanks for any help.
