Help

Formula returning extra character

Topic Labels: Formulas
818 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Katy_Richards
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi

I have a formula that compares a rollup to a text field and then returns any new additions to the rollup. However it seems to be returning an extra character, could anyone help me figure it out please?

From this:

'Nelson Dance Festival- 2024, Royal Tunbridge Wells Dance Festival- 2024, Blackburn Festival of Dance- 2024, Dudley Festival- 2024'

I would like it to return 'Dudley Festival- 2024'

But I'm getting '4, Dudley Festival- 2024'

The formula is this:

IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0,RIGHT(ARRAYJOIN({Rollup Festivals Entered}),(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered}))))
 
What am I missing?
 
2 Replies 2

 
What am I missing?
 

new element brings new separator, (+2 chars).
you can adjust your formula with -2. but I would use REPLACE instead of RIGHT

IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0,
  REPLACE(ARRAYJOIN({Rollup Festivals Entered},', '), 1, 2+LEN({Static Festivals Entered}),'')

Thank you so much for your help! With an extra ')' it worked perfectly!

IF(LEN(ARRAYJOIN({Rollup Festivals Entered},", "))-LEN({Static Festivals Entered})>0,
  REPLACE(ARRAYJOIN({Rollup Festivals Entered},', '), 1, 2+LEN({Static Festivals Entered}),''))