Hi ! I would like to add those excel formula...

[Thomas_Duhamel]

Hi !

I would like to add those excel formulas in appsheet (not as spreadsheet formula but as App formula), can you help me ?

=IF(C2="","",MID(C2,1,(SEARCH(",",C2,1)-2)))

=IF(D2="","",IF((RIGHT(D2,LEN(D2))&",")=RIGHT($C2,LEN(D2)+2),"",MID($C2,SEARCH(",",$C2,1)+2,(SEARCH(",",$C2,((SEARCH(",",$C2,(LEN(D2)+3)))2))-2)(SEARCH(",",$C2,1)+1))))

Thanks !

[Steven_Coile]

What do you need help with?

[Thomas_Duhamel]

I need to translate those formaulas into Appsheet formulas.

Eg :

C2="" in Appsheet is ISBLANK(name of the column C)

What is the correct Appsheet formulas for : . MID() . SEARCH() . LEN()

Thank you

!!

[Steven_Coile]

@Thomas_Duhamel There is no AppSheet equivalent of MID().

FIND() in AppSheet is equivalent to Excel’s SEARCH().

LEN() is the same in AppSheet as it is in Excel.