Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Show un-selected options from multiple select field in a separate field

Topic Labels: Formulas
405 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a couple fields that are all multiple selects, that I want to consolidate to one field that tells me what wasn’t chosen.

For Example, I have 3 fields called VIDEO, AUDIO, GRAPHICS all with multiple options to select. I want to create a field that combines them all with the unselected options.

If VIDEO has the options: Master, Web, DCP and I select only Master and DCP
If AUDIO has: Stereo, 5.1, Stems and I select only Stereo, 5.1
If GRAPHICS has: poster, stills and I select only poster
Then I want one field Called Missing that outputs the missing options: Web, Stems, stills

Thank you.

1 Reply 1

Anyone have a possible solve for this?

Thank you.