Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we need to create, we have multiple columns with multi-select dropdowns for each asset by department name. What my goal was to have the user select all the assets by each department to be created. Once they hit save, Control Center would use a blueprint built for each asset under each department to generate the asset. Once created, it would put it in a predetermined workspace.
The issue I'm coming up with is, in Control Center, under the Intake Settings in the "Project Approval Column" and then sub cell, "Approval Value." It doesn't recognize the the source sheet column as a multi-select column vs just a single select dropdown. Since it doesn't recognize it, it won't provision the request, (Manually or with automation in CC).
I could create separate columns for each Asset to be created by each department and then the system could work but that's a lot of upfront work. I wasn't anticipating Control Center not recognizing a multi-select column for the "Approval value." Has anyone found workarounds for this?
Thank you - Michael