MULTI-SELECT from two DIFFERENT linked sheets

How to achieve a MULTI-SELECT field from two DIFFERENT linked sheets?
“Sheet: MAIN” has a multi-select field “short-name” to be linked to the fields: “short-name” in “sheet: A” and “sheet: B”.
One solution would be to have two linked multi-select fields in MAIN (to A and B) and then merge them together via FORMULA in sheet: MAIN.
Merging sheets A and B is not an option.
Any better ideas?


A field can only link to one field instead of multiple fields. You’ll need to create another field to link to sheet B.

1 Like