COUNTIFS + CONTAINS with a contact list

Hello! I am trying to use a COUNTIFS formula with a CONTAINS formula for a list of contacts. The formula needs to count if a project is a certain phase, and if the assigned project lead is one of the designated contacts in the list of contacts I have. Can someone please provide an example of what this formula would look like? Everything I have tried had not worked, and I am not sure what the root problem is.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!