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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!