Would This Be an Index/Match Formula?
So I have a workspace for a client install we're doing. I have another workspace where I manage our company employee contacts. For the client install workspace, I'd like to create a widget to access the contact info based on "assigned to" in the client intake sheet. Is this an Index/Match formula where I need to create a sheet if the "assigned to" is person A on the client install intake sheet, then populate person A contact row from employee contact sheet?
Hope I make sense
Help Article Resources
Check out the Formula Handbook template!