Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Using a Lookup field in a formula

1868 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jenny_Arntzen
5 - Automation Enthusiast
5 - Automation Enthusiast

I am putting task items into a schedule and assigning People who will work together to get the task done. The task is one line in the Schedule table. I have linked to the People table (fk_People) and then linked multiple people, depending on who is going to be working on the task.

I made a lookup field from the People table so only their first names show in the field (Name_F). Thus - if I have assigned Trevor and Matt to the task, their names show up as

Trevor, Matt

in the lookup field. This is what I want to show up in the formula field.

I have made a formula field to bring together the name of the task and the first names of the people assigned to work together:
Name_Task & " - " & Name_F

My problem is that the formula returns the Name_F lookup so that it looks like this

TrevorMatt

instead of

Trevor, Matt

I must be missing something - but I cannot figure out where to look to get the answer.

4 Replies 4

Hi Jenny, try changing it to:

Name_Task & " - " & ARRAYJOIN(Name_F)

I think that should solve your problem, and I’ve put a base together here as an example

(You could also change your lookup field to a rollup field)

Screenshot 2022-09-10 at 3.24.03 PM

That is much better - I guess there isn’t anyway to get that space after the commo in the ARRAYJOIN - to improve readability?

Otherwise, I will use this - it is better than setting up a formula to do the work.

Thanks!

Nah you can, try this: Name & " - " & SUBSTITUTE(ARRAYJOIN({Lookup}), ',', ', ')

Jenny_Arntzen
5 - Automation Enthusiast
5 - Automation Enthusiast

That fixed the problem. Thank you for your help. Really appreciated.