
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2023 12:23 AM - edited Oct 16, 2023 02:07 AM
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:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2023 05:59 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2023 05:59 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2023 07:07 AM
More info on using array functions via this link.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 16, 2023 08:42 AM
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!🙏
