CountIFS with two conditions

Carrie Tortorella

In a smartsheet formula I am trying to count the number of rows for a column "Hierarchy" equal to 0 with the condition that Health column is equal to red. I wrote the formula like this but it isn't working: =COUNTIFS(Health:Health,"Red",Hierarchy:Hierarchy,0). What am I doing wrong?

Colleen Patterson

@Carrie Tedesco Missing the quotes around the 0. :)

=COUNTIFS(Health:Health,"Red",Hierarchy:Hierarchy,"0")

Carrie Tortorella

@Colleen Patterson thank you - I had tried that too but still results in "Unparseable". Any other thoughts?

Razetto

@Carrie Tortorella I tested your formula in the sheet summary and it works fine. Is yours within the sheet?

Colleen Patterson

@Carrie Tortorella to confirm, these are columns in the same sheet where you are writing your formula?

Carrie Tortorella

@Colleen Patterson @Razetto Yes both columns are in the same sheet, but I'm putting the formula in a Summary field.

Razetto

@Carrie Tortorella Not sure why it wouldn't work unless, maybe, the problem is the type of columns being used. I tested out with the health as a symbol column, hierarchy column and count field in summary sheet are both text.

Carrie Tortorella

Thank you both! I'll keep working on it.