Pull specific values from a column in one sheet to another
Hi! Hoping to find an answer to what seems to be something simple, but may not be.
I have a sheet with a list of project types (as values in a dropdown list). In another sheet, I am using Smartsheet DataMesh to pull specific columns over, but for that project list, I only want one project type (example: Display Ads only).
I can see that DataMesh will not allow me to pull over only a specific type. I do not want to use a filter, because the other users do not need the other data at any point. I also don't want a total. I am looking to pull full raw data of just this project type. Is there another way to accomplish this?