Trying to do a COUNTIF two columns fall under a certain criteria


I am trying to create a formula in my sheet summary that will provide the count for a completed project with a certain firm. I only want the formula to provide the count if it is both status green and analyst firm gartner. Status being the one column and analyst firm being the other. I keep getting the error: #UNPARESABLE. Here is my current formula:

=COUNTIF([Analyst Firm]:[Analyst Firm], "Gartner")AND(Status:Status, "Green"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!