Help

Removing a comma from lookup field

Topic Labels: Formulas
Solved
Jump to Solution
459 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sareyh
4 - Data Explorer
4 - Data Explorer

I am looking to remove the comma separating the two lists. Here is a picture to show an example.

Screen Shot 2023-10-12 at 4.07.43 PM.png

 

 

 

 

Is there a way to do this?

Thanks!

1 Solution

Accepted Solutions
Ella
7 - App Architect
7 - App Architect

Hi @Sareyh ,

If you use a roll up for the {List} field, then in the roll up formula you can specify how you want all the items to be listed ( comma, no comma, line breaks etc). I think this video might help you as it explains it better than I can:

https://www.youtube.com/watch?v=ttcOR-qUC9w

See Solution in Thread

2 Replies 2
Ella
7 - App Architect
7 - App Architect

Hi @Sareyh ,

If you use a roll up for the {List} field, then in the roll up formula you can specify how you want all the items to be listed ( comma, no comma, line breaks etc). I think this video might help you as it explains it better than I can:

https://www.youtube.com/watch?v=ttcOR-qUC9w

Thank you! I had tried this previously but it didn't work cause it was a lookup field, realized I had to do it in the table it was linked to.