I’ve created a base for managing a complex calendar at my institution. I’ve created simple table and calendar views for collaborators, but I also have a table view that is strictly for exporting csv files so I can upload the events to our website since there are strict rules for formatting, etc.
All of the events have to have categories, some of which have up to three. I’ve created a multiple select field (“Category”) so people can select the appropriate categories. But when I export to csv, there can only be one category per column. I would rather keep a single “Category” multiple select so I don’t have three separate fields that people have to figure out. Is there a way to write a formula for this?
So the logic would be this:
- I would create three fields (Category 1, Category 2, and Category 3).
- Category 1 would find the first option in the Multiple Select field “Category.”
- Category 2 would find the second option in “Category”
- Category 3 would find the third option in “Category”
