The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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 ...