IF formula to auto-populate in another table

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.

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

IF(
    DATETIME_DIFF(
        NOW(),
        {DueDateAndTime},
        'seconds'
        ),
    '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.

1 Like