Invalid spreadsheet-style formula error

Hi there @Suzuki 👋

It looks like the selected Records Title fields have double quotes (") that are breaking the formula: 

I’d suggest using a Text > Replace (Formatter) action to remove the quotes from the Records Title field. Then in the formula, instead of selecting the Records Title field you’d select the output from the Text > Replace (Formatter) field instead. You can learn more about how to use that Text > Replace (Formatter) action here: Find and replace values in your Zaps

Can you give that a try and let us know if that fixes it?

Thank you for your reply.

But the problem persists.

If you include an action that formats double quotes, empty elements will disappear.

I also need to replace empty elements with NONE.

Thanks for giving my suggestion a try ​@Suzuki, sorry to hear it didn’t work as hoped.  

I just ran a quick test in my own Zap using the same text that’s in that Records Title field and manage to get the formula to work.

I set up a field called Records Title in Salesforce and added text that was similar to what appeared in your screenshot (I couldn’t find an exact match for one of the characters but it should work the same for any text that’s included in the Records Title field):

Next, I set the formula to use the output from the previous Formatter action like so:

And that output the value from the field (with the double quotes removed):



And when the field contained no data:


The formula returned a value of “NONE”:

Can you compare the above screenshots with your Zap and update the Zap if it doesn’t match?

If the setup of those Formatter actions in your Zap does match and it’s still not working can you send over some screenshots showing the current setup of the Formatter actions in the Zap so I can take a closer look to see what might be preventing it from working?

Thanks, I look forward to your reply! 🙂