Countifs: Using a reference for the criterion
I have a summary sheet that includes the following columns.
- Ticket#
- Last Name
- First Name
- Biosketch
In the Biosketch column (and two others), I'm using the formula: =COUNTIFS({GH Ticket #}, 1114, {Last Name}, "Meyer", {Bio}, 1)
I would prefer to use a reference to the column in the summary sheet instead of typing "1114" and "Meyer".
Each row has a different ticket and name value, so it's cumbersome to update the formula three times for each row.
Any suggestions?
Thanks in advance...
Diane M. Meyer
Iowa State University
Ames, IA 50011
Comments
-
Hi,
You can use the @row function instead.
Try something like.
=COUNTIFS({GH Ticket #}, [GH Ticket #]@row, {Last Name}, [Last Name]@row, {Bio}, 1)
Did it work
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Diane M. Meyer
Iowa State University
Ames, IA 50011
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!