Trying to use a formula in the summary sheet with an AND to look at values from two columns


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!