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”
),
“Gift...
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 ...