CountIF with dynamic criterion
Options
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
Best Answer
-
Ok if that is the best way to do it i will give it a crack, much appreciated
Answers
-
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.
-
Ok if that is the best way to do it i will give it a crack, much appreciated
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!