CountIF with dynamic criterion

Stewart Ennew

Hi i'm trying to count the number of rows in a Smartsheet where the name in the "Engineer" column is the same name in the "Approved By" column

I can get it to work by looking at a single row

=IF(Engineer4 = [Approved By]4, COUNT(Engineer4))

but seem to look at all the rows in both columns and count the rows that match, is this possible?

many thanks

Stewart Ennew

Ok if that is the best way to do it i will give it a crack, much appreciated

Paul Newcome

You would need to add in a helper column with a formula to flag all matching rows. Then you would count the number of flags in the helper column.

Stewart Ennew

Ok if that is the best way to do it i will give it a crack, much appreciated