The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have a table that includes a date field as well as a single select field with options that are times of day (e.g., 9:00am, 12:00pm, 3:00pm). This allows users to select a date and time from a limited set of time options rather than Airtable's unres...
How can I configure an automation to only run (or complete given n steps) if it hasn’t run within t hours or minutes?
I have a couple automations that watch for various sporadic updates to tables in my base. On occasion, these updates happen close to...
My assumption is that it does not. How can a person ensure that an API query is retrieving the most recent data? Is it possible to trigger Airtable Sync via API?
The form view on Airtable currently doesn’t support prefilled hidden fields.Being able to receive input for hidden fields would be very helpful. Being able to receive this input in various ways would be even better. Ideally, you would be able to assi...
Hi @JaclynB, both of the formulas in my initial response include your original formula. The two formulas I offered are two ways of doing the same thing. You can use the one you prefer.
You could write this at least two ways.1) Using ISERROR:IF(
ISERROR(
WORKDAY(
{Start Date},
{SLA Test}
)
),
"",
WORKDAY(
{Start Date},
{SLA Test}
)
)2) Checking for values in the relevant fields:IF(
AND(
{S...