"IF then" question

[Susan_Colantuon]

Is it possible to set something like this up and if so, how?

• If the answer in Column 1 is X, then display these multiple choice options for Column 2
• If the answer in Column 1 is Y, then display these totally different multiple choice options for Column 2

I’m a brand new user, so please account for that in any answers.

Thanks!

[Justin_Barrett]

Welcome to the community, Susan! :grinning_face_with_big_eyes: Unfortunately Airtable doesn’t allow for a multi-select field to have its options change based on another field. At least, not natively. It can be done with a bit of setup, which has been figured out by @W_Vann_Hall and documented in this thread:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…

[Susan_Colantuon]

Thanks for your response, @Justin_Barrett
Lots here to digest. Will let you know how it goes…but might take a while.
S