PB with formula with multiple results + text (Notion like style) - is it doable with airtable?

Hi everyone,
I try searching the numerous existing posts but I couldn’t find my answer.

Here it is, I need to migrate a database from Notion to Airtable and I’m not sure if the formulas in airtable enables me to do the same as the existing Notion one :slight_smile:

Having a formulas counting different multiple select occurences and adding text within the results too (cf screenshot)

So the idea, as a result, is to get 1 line per language with the total of the different languages occurences:
Français : 4
Espagnol : 5
Anglais : 2

I tried something like

IF(LEN(SUBSTITUTE(Maternelle, "Français", ""))>1,"Français:"+(LEN(Maternelle) - LEN(SUBSTITUTE(Maternelle, "Français", ""))) / 8,"")

But I get NaN as a result → does it mean formulas can’t have calculation + text as a result ?

and doing it for several languages

IF(LEN(SUBSTITUTE(Maternelle, "Français", ""))>1,(LEN(Maternelle) - LEN(SUBSTITUTE(Maternelle, "Français", ""))) / 8,"")+IF(LEN(SUBSTITUTE(Maternelle, "Espagnol", ""))>1,(LEN(Maternelle) - LEN(SUBSTITUTE(Maternelle, "Espagnol", ""))) / 8,"")

BUT I get one total number as a result so not what I want either

Thanks for your help ! I guess Airtable can allow me to do what Notion does but still new to it so not sure…

Anyone on this one ?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.