The first clue is that the formula ends with “)))” but there is only one IF.
That means that you have an extra parenthesis or you have one or more parentheses in the wrong place.
Try this:
IF({Mix Date},CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEA...
FWIW, the limit on the number of records is per base, not per table.
See Airtable pricing.
With 75,000 records (regardless of how many small tables you create), you’ll need to upgrade to the Enterprise subscription.
Unless I’m missing something about...
Hi Oliver.
Here’s the formula:
IF(NOT(AND(Col1,Col2,Col3)),"!")
If all three fields are not blank, then show nothing.
If at least one of the fields is blank, then show “!”.
This is an equivalent but longer formula:
IF(OR(NOT(Col1),NOT(Col2),NOT(Col3)...