I setup a Zap to update one table from a base without date from another table. It works great but the problem is that I want the update to only add the new data to the existing one (I am updating 2 fields: attachments and a long text field). So far w...
I am trying to return “Late” when one or several function fields have a date that’s before today AND an attachment field is empty. I have tried the following formula but it’s not working. What am I doing wrong?
IF(
AND(
IS_BEFORE(
{Due Date Sponsored...
I am trying to use Airtable to consolidate all the ways we manage your ad inventory (we are a publisher of websites). Ideally, I would like a form where ad sales rep can enter all information when a campaign is booked, and see in a calendar view what...
Here you go: https://airtable.com/shrGqqPEPFL5p1sQ7
Don’t hesitate to ask any question, not sure it will make sense for people who don’t know our processes…
Thanks Elias. I tried that but got the same result (meaning no result).
IF(
AND(
OR(
IF({Due Date Sponsored Article},
IS_BEFORE(
{Due Date Sponsored Article},TODAY())),
IF({Due Date Sponsored Agenda},
IS_BEFORE(
{Due Date Sponsored Agenda},TODAY())),...
I am trying to use an IS_Before check date with AND, IF and OR. It’s working but only when all date fields have a date. If a field is blank, it returns ERROR.
Then I tried to wrap each IS_BEFORE check in an IF(). No more errors, but the formula doesn...
Thank you Elias
I am getting Error returned whenever one of the dates is blank (which happens most of the times). When all date fields have a date, it works fine.
