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
-
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!