Nested Formula in Sheet Summary

I am looking to return a summary sheet for manager review.

I want a formula to run if the status is "In Progress" and it's been assigned to a specific team member, I want the value returned to be a list of the types of projects in progress. The sheet is set up with "Assigned to" as a contact list, "Status" to be a drop down list, and "Project Type" is a multi select drop down list.

Is this possible?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!