Aug 24, 2019 12:32 PM
New to Airtable and forumulas. I have one multiple select column with a various office building names. Can I create a formula for If office building X then address column will contain specific address? How would I right that? Thanks.
Aug 25, 2019 06:42 AM
You would either use a IF()
formula or create a table for Office Locations and use a Lookup field.
The formula option would be something like this:
IF(FIND('Office A', {multiple select field}), 'the address for Office A')&IF(FIND('Office B', {multiple select field}), 'the address for Office B')&IF(FIND('Office C', {multiple select field}), 'the address for Office C')
The new table option would have one column which names each building and another column for the address. Your original table would use a Link to Another Record field to connect to the new offices table instead of a multiple select field, and your address column would be a Lookup which will reflect the addresses from the new table.
Either option should work for you.
Aug 25, 2019 09:54 AM
Much better I think! :clap: