I would like to create a formula to search 1 field and return the search results comma separated.
This formula only returns the last item found not all of them.
IF(FIND(“text1”,{field}),“text1”,"")&IF(FIND(“text2”,{field}),“text2”,"")
Ideally, this w...
Thank you so much for this Zollie!
It still didn’t work but I discovered that it was because I was using FIND on a “Lookup” type field which only pulls the last item for some reason (Airtable, are you listening?).
It works perfect on a Link to Anothe...
