Help

Removing a comma from lookup field

Topic Labels: Formulas
Solved
Jump to Solution
1031 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sareyh
5 - Automation Enthusiast
5 - Automation Enthusiast

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

⭐️ Part of a business or enterprise team? Access my services - https://www.3rings.co ⭐️ Product Comparisons Airtable vs Excel - https://youtu.be/RHFvUmptIs0 Airtable vs Notion - https://youtu.be/kFJ6ddr3lVI ⭐️ Airtable Basics Airtable for Beginners - https://youtu.be/XoJJwSgrIJM Linked Records - ...
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

⭐️ Part of a business or enterprise team? Access my services - https://www.3rings.co ⭐️ Product Comparisons Airtable vs Excel - https://youtu.be/RHFvUmptIs0 Airtable vs Notion - https://youtu.be/kFJ6ddr3lVI ⭐️ Airtable Basics Airtable for Beginners - https://youtu.be/XoJJwSgrIJM Linked Records - ...
Sareyh
5 - Automation Enthusiast
5 - Automation Enthusiast

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.