Trouble creating COUNTIFS

edited 12/09/19 in Smartsheet Basics

For the life of me I cant get SS to sum certain target values.


For example I have an "Audit Status" column with drop down functions, some of these functions represent being "completed" and I have a sheet that I want to reference these variables as combined.

i.e. Completed, Not Required, QC Complete, and Bypass QC all mean that we have had an auditor onsite, but I cant get them to calculate in another worksheet as a reference calculation.


I tried unsuccessfully to use the "or" function and the "&" but always get 0 as the returned result... Im stumped