Countifs Find Formula Help
Hello! I'm working on a formula to capture individuals involvement on projects. I currently have the following formula set up to track projects:
=COUNTIFS({Contact Columns}, FIND("First Last", @cell) > 0)
I would like to add a condition to this so the formula only looks at projects with a status of "In Progress". I've tried adding another "If" statement to the formula but keep getting an error message. Does anyone know if/how I can add this condition to the formula?
Thanks!
Answers
-
See below, you can keep on adding ranges and criteria... Add/setup the cross sheet reference as needed
=COUNTIFS({Contact Columns}, FIND("First Last", @cell) > 0,{Project Status},@cell="In Progress")
-
Hi @anuelle,
Try this formula - it will work :)
=COUNTIFS(Owner@row, FIND("Sofia", @cell) > 0, Status@row, "In Progress")
Hope this helps,
Cheers!
Ipshita
Ipshita Mukherjee
-
@Leibel S I've tried your suggestion and am still getting an "Incorrect Argument Set" error. Could this be due to the fact it's a cross-reference formula?
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!