Use a lookup to display select list values

1

Hello,

I’m looking to pull selected values from a multiple select list in one table into a lookup in another table, however I am unable to get the correct formula to do so. Has anyone done this before that can guide me in the right direction?

Thanks!

2

Dear @erik,

If I understand your situation, you might want to check this

Dependency of task

3

Thank you for the response. I’m building out a Dev doc with all the same tables, etc just fake data so I can share it. I’ll post the link here when I’ts ready.

Thanks!

4

@erik

Here is one possible approach:

5

Here is the link to the dev doc. https://coda.io/d/DEV-Monitoring-and-Automation_d7BE7ouyNIt

I have under Admin (Core DBs) => Tags a list of tags. Under Admin (Core DBs) => Automation Template there is a coulmn for “Select Tags” where I can choose which tags the automation fits under.

If you look at the Admin (Core DBs) => Client + Template Automation table it has a tags column which currently shows all tags instead of just the ones selected under the select tags column in the automation template table.

I’ve tried quite a few different formulas on this and cannot come up with the expected result. Any help is appreciated.

Thanks!

6

Thank you @Ander for the assist.

1 Like