Need help with a formula to create a pick list from a column on another sheet
We have a Project Intake Sheet that lists the Clients, the Status (active, etc) and the PM's working with each client.
When filling out the Issue/Risk log, I'd like the values which appear in the cells in the client column to be presented as a single option pick list and be limited to only the active projects which the PM is assigned as listed on the Project Intake sheet.
Does anyone know if this is possible and how to create a formula to do this?
Help Article Resources
Check out the Formula Handbook template!