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 !
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |