Hi,
You can forget BLANK() in Airtable and use just IF(Inspection, Art&....rest_of_your_formula
You can omit brackets for one-word field names, but some users prefer to use them for all, to mark fields.
If you want to get your output without quotes, wrap your formula into substitute ( " to nothing):
SUBSTITUTE(
IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")")
'"','')
Hi,
You can forget BLANK() in Airtable and use just IF(Inspection, Art&....rest_of_your_formula
You can omit brackets for one-word field names, but some users prefer to use them for all, to mark fields.
If you want to get your output without quotes, wrap your formula into substitute ( " to nothing):
SUBSTITUTE(
IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")")
'"','')
Thanks much Alexey!
There was a comma missing from the end, but I figured it out (in red).
And now I can use the same formula to fix some other errors I've come across (extra spaces in things), so I'm very grateful, thanks again!
SUBSTITUTE(
IF({Inspection},{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")") , '"','')