It’s not a sync dependency, but anecdotal reports seem to indicate that your formula will update every few hours when your base is closed. Somewhere between 1 and 3 hours. Please test it out and report back with your findings!
However, a better way of doing it would be to use Integromat instead of Zapier, which has a built-in scheduler, full Airtable support, and none of the limitations of Zapier’s platform. It’s essentially the “next-generation Zapier”. It’s cheaper, too!
Zapier’s Airtable support is extremely limited, and its biggest weakness is that it will never re-trigger on a record entering a view if the record leaves and re-enters the view. You can also try scheduling in Zapier, but it requires a JavaScript hack to make it work.
