Skip to main content

I have an IF formula to populate a name column.  

I’m putting in a substitute formula to remove extra spaces, and it appears to be accepted (no errors) but then it just vanishes.  It leaves the “Substitute” there, but not the info about removing the spaces.

Here is my original formula:

Here is the substitute formula showing no errors:

 

When I hit confirm change, it reverts to this:

 

Any help would be appreciated, I have no idea what I’m doing wrong.  (And apologies for the large screenshots, I’m unable to make them smaller for some reason).

In your 2nd screenshot, you put both of your closing parentheses at the end of the formula.

But the first closing parenthesis needs to come after the final {Full Name (Manual Entry)}.

So you need to keep the 1st screenshot intact, but just put the SUBSTITUTE function around that entire formula (as if it was a long string of text).

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Does this look right?


If so, here’s the formula:

SUBSTITUTE(
  IF(
    {Full Name (Manual Entry)}=0,
    {S&B App LINK},
    {Full Name (Manual Entry)}
  ),
  ",", " "
)

You can also check whether a field has a value by just using the field name instead of doing a ‘=0’ too:

SUBSTITUTE(
  IF(
    {Full Name (Manual Entry)},
    {Full Name (Manual Entry)},
    {S&B App LINK}
  ),
  ",", " "
)
Terms & Conditions