CountIF with dynamic criterion

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!