Is there a formula to read other fields to determine a "multiple select" field's selections?

Greetings! This is my first post here in the airtable community.

I’m importing a data set that has a series of fields that are using binary (0’s and 1’s) to allocate tags to a record. Ie: The “green” field is either a 0 or 1 to tell me that the record is green.

I’d like to create a formula or automation that will read these 6 fields of 0’s and 1’s into a single “multiple select” field that displays the associated tags.

Any clues or articles I should start with? Very new to formulas and automations.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.