I’ve been able to use nested IF formulas to strip out forbidden characters (like spaces, slashes, etc.), but cannot remove quotation marks. I suspect Airtable just doesn’t like “”".
Any help here? Thanx!
I’ve been able to use nested IF formulas to strip out forbidden characters (like spaces, slashes, etc.), but cannot remove quotation marks. I suspect Airtable just doesn’t like “”".
Any help here? Thanx!
Have you tried escaping the quotes in the formula? E.g. SUBSTITUTE("\"", "")
? I haven’t tested this, but it might work.
Boom; worked perfectly. THANX!
Thank you. Save me lots of frustration. This must be an Airtable bug that they don’t even mention.