Formula Text to Multi-select field

[Mae_Infante]

Hi All,

I have an automation issue coming from a formula field.

The lookup field is coming from Tasks table, and the regions are repetitive, so i created a formula to make it as a text and im hoping the automation will take the Regions Text to a normal editable field 'TASKS - Regions', but it updates it with a blank value in the end (the blue circle in the end). Im not sure why, but if someone can help me with this.

the formula im using is:

CONCATENATE(

IF(FIND("KSA", {Regions (from Task Tracker)}), "KSA, "),

IF(FIND("GCC", {Regions (from Task Tracker)}), "GCC, "),

IF(FIND("Levant", {Regions (from Task Tracker)}), "Levant, "),

IF(FIND("EGY", {Regions (from Task Tracker)}), "EGY, "),

IF(FIND("WW", {Regions (from Task Tracker)}), "WW, "),

IF(FIND("NA", {Regions (from Task Tracker)}), "NA, ")

)

Not sure if there is something wrong with the formula or its the automation, which is when the lookup field is updated, take the Regions text and update it in 'TASKS - Regions' field.

Thank you in advance!

[Sho · Accepted solution]

Hi @Mae_Infante ,

"," at the end, as in "NA," so an empty value would be added.
Last comma would need to be removed.

Is this a case where you can't use Arrayunique(values) in the Rollup field?

[Databaser]

More info on using array functions via this link. 

[Mae_Infante]

Thanks @Sho ,

I actually didn't use the formula I added above, when you mentioned about the rollup field, a light bulb popped in my head🤗. I used the rollup field and linked to the specific field I wanted, and I used the Update automation. Thanks again!🙏