Is there a way to pull a list of names from a sheet based on another name?
I have a sheet that has employee names, supervisors and some other data. I am trying to have Smartsheet automatically pull the names from the sheet and input them into a metric sheet. I can Make INDEX MATCH work with a some changes but only if I know the exact number of rows on the Metric sheet.
Help Article Resources
Check out the Formula Handbook template!