Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 23, 2023 04:48 AM
hello community What would be the formula for to extract from the rollup field "participant name (from imported table)" the names entered in this field and to report them individually in the formula fields, do you have an idea of the formula to use thank you Franck
Jun 24, 2023 12:34 AM
Jun 24, 2023 01:34 AM
hello and thank you for your answer, my skills are limited with regard to such complex formulas, I tried several options but the result returns an error! Best regards
hello and thank you for your answer, my skills are limited with regard to such complex formulas, I tried several options but the result returns an error! Best regards
Jun 24, 2023 02:20 AM
I found the solution by adding "ARRAYJOIN" in the formula.
Modify location 1 ([^,]+,?){1}") to extract the rest of the string in the following fields.
best regards
Jun 24, 2023 07:36 AM
Hello
But here is the problem I encounter on fields that do not contain data
Ex
Lookup contains
ALLIE Pierre, BELUFFI Maeva, MUD Adrien
Formula 1 field 1 =ALLIE Pierre
Formula field 2 = BELUFFI Maeva
Formula field 3 = MUD Adrian
Formula field 4 = n
Formula field 5 = n
https://airtable.com/shroD4pRoA52pXcg6
Thank you for your feedback
Best regards
Frank