Best answer

List cell values, and separate each with comma, but for last one use 'and' to separate

  • 5 September 2020
  • 2 replies
  • 162 views

Userlevel 1

Hi, how would I list cell values separated by comma, but for the last value separated by the word "and".

For example, 'Apple, Orange and Pear'.

If the third cell is empty, then 'Apple and Orange'.

Thank you.

icon

Best answer by Troy Tessalone 6 September 2020, 18:19

View original

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

2 replies

Userlevel 7
Badge +14

Try a Code step: https://zapier.com/apps/code/help

Otherwise you’ll need to use Filter/Paths with Formatter steps.

Filter: https://zapier.com/apps/filter/help

Paths: https://zapier.com/help/create/customize/add-branching-logic-to-zaps-with-paths

Formatter: https://zapier.com/apps/formatter/help

Userlevel 1

Thank you Troy