If then formula help

862 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

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.

Much better I think! :clap: