Help

Need help with nested SUBSTITUTE formula

Topic Labels: Formulas
Solved
Jump to Solution
746 2
cancel
Showing results for 
Search instead for 
Did you mean: 
MSB_Archive_Adm
5 - Automation Enthusiast
5 - Automation Enthusiast

Can you spot an error with this formula? I’ve tried multiple variations and keep getting, “Sorry there was a problem saving this field. Invalid formula…”

SUBSTITUTE(
SUBSTITUTE(
    SUBSTITUTE({Status},
        “Destroyed”,”Sold”
        ),
    “Gifted”,”Sold”
    ),
“Stored/Loan”,”Sold”
)
1 Solution

Accepted Solutions
augmented
10 - Mercury
10 - Mercury

I think it’s those curly quotes. Look at them closely on “Sold”. It looks like double closed curly quotes.

I’m not sure how you make them, but with normal double quotes your formula works for me.

See Solution in Thread

2 Replies 2
augmented
10 - Mercury
10 - Mercury

I think it’s those curly quotes. Look at them closely on “Sold”. It looks like double closed curly quotes.

I’m not sure how you make them, but with normal double quotes your formula works for me.

You were correct! I was pasting from the Apple Notes app and so after reading your comment, I re-wrote the code in Visual Studio and then pasted it into Airtable and voila! It worked. Thank you! the quotes in Apple Notes were not being read properly by Airtable.