Help

Formula Text to Multi-select field

Topic Labels: Automations Formulas
Solved
Jump to Solution
1469 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mae_Infante
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi All,

I have an automation issue coming from a formula field.

Mae_Infante_1-1697440682274.png

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!

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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?

See Solution in Thread

3 Replies 3
Sho
11 - Venus
11 - Venus

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?

More info on using array functions via this link

Mae_Infante
5 - Automation Enthusiast
5 - Automation Enthusiast

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!🙏