Adam from Airtable here. Welcome to the community.
There are many ways to approach this (Automations, Sync, etc.). In this case, I think a combination of a formula field, linked record field, and lookup field (or rollup, depending on your specific workflow) can accomplish what you are looking for.
Adam from Airtable here. Welcome to the community.
There are many ways to approach this (Automations, Sync, etc.). In this case, I think a combination of a formula field, linked record field, and lookup field (or rollup, depending on your specific workflow) can accomplish what you are looking for.
Airtable operates a bit differently than traditional spreadsheet software like Google Sheets or Excel. In this case, our Automations feature might be the better route. I will say though, that your setup may be a sign of less-than-ideal base design within Airtable. More here…
Airtable operates a bit differently than traditional spreadsheet software like Google Sheets or Excel. In this case, our Automations feature might be the better route. I will say though, that your setup may be a sign of less-than-ideal base design within Airtable. More here…