Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Changing - to ordinal numbers (1,2,3,4,5 etc.)

Topic Labels: Automations
158 0
Showing results for 
Search instead for 
Did you mean: 

Hey guys,

So I have rollup field addresses, and I made a little formula to put “-” in front of every address.

But I would like to change hyphen symbol (-) to number - first row number 1, second row no.2 and so on.

Current formula in Addresses field is:
" - " & ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values)), ’ ; \n \n - ') &"."

Is that possible?

0 Replies 0