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!
