I have a link that may change regularly. I have put it in a tab with a single cell, and want it to propagate across all my tabs using a lookup, without having to explicitly have it look up ever single time.
Is there a way to pull a cell from another tab into a formula for a column?
(Basically, it’s a meeting ID that needs to be on every row in each tab - pulled from a single source)
You could have every table link to the table with single set value, and then pull the value into the other tables with a rollup/lookup field. However, you would also need a mechanism to ensure that every record (including newly created records) is linked to record with the set value. It is possibly with automations, but it might be more trouble than it is worth.