IF formula to auto-populate in another table

Topic Labels: Formulas
1042 1
Showing results for 
Search instead for 
Did you mean: 
8 - Airtable Astronomer
8 - Airtable Astronomer

How do I get information from one table with a certain status (on schedule) to automatically update to another table?

All of my tables are linked, but I cannot get the IF formula to move the information to another table automatically.

1 Reply 1

I’m not sure about your base architecture, but one way would be to create a conditional field in the first table that is either empty or contains the desired status, depending on your schedule — something like

    'Status Value'

Then, in your remote table, use a lookup or rollup field to reference the conditional field you just recreated.

The mechanism is a little different from how you describe it: You seem to imply you want to push a value from your main table to your secondary table — which can’t be done in Airtable. (However, it is conceivably possible using a SaaS integration service, such as Zapier or Integromat.) Instead, what you want to do is pull a value from your main table into your secondary table. This is done using a lookup or rollup field, with the secret being to make sure the pulled field is empty until expiration of your schedule.