Skip to main content
Question

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

  • February 28, 2024
  • 1 reply
  • 157 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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 28, 2024

Hi @tshemphill 

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