Question

How do I use Zapier's Formatter Spreadsheet to concatenate a constant to the beginning of each line item?

  • 28 February 2024
  • 1 reply
  • 21 views

I am trying to use Zapier Formatter with a spreadsheet function to concatenate a constant to the front of each line item thusly - “constant” & line item output from a previous step.  It doesn’t recognize the ampersand as a function...perhaps because it isn’t a line item function? Yet, I don’t see a concatenate spreadsheet function other than this.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @tshemphill 

Try using the line item options found here: Formatter > Utilities