Could you give solution for this matter ? Thank you very much if you respond Data ilustration (3 columns in 1 table) col.1: A,A,B,C,C,C.........etc col.2: H,I,J,......... etc col.3: 1,2,1,1,2,3 (sample data that I want, it is filled automatically), my question : What is the formula for column 3 to automatically fill in numbers, based on the data in columns 1 and 2 (AH=1,AH=2;BI=1;CJ=1,CJ=2,CJ=3....etc), I know the formula in google sheet (=COUNTIFS($B$2:$B2,$B2)) but don't know in the appsheet, please...thank
Switch() may be the best way. switch([col1]&[col2], AH, 1, AH, 2, BI, 1, nextcond, nextresult, catchall value) The first part of the switch function concatenates col A and B. Then follow pairs of conditions and results. Just keep adding on more as needed. The last value is a catch all value if non of the previous pairs match.
![MISSING: SLIM SHADY [Expanded Mourner’s Edition Trailer]](http://i.ytimg.com/vi/xh8qgHrOO1g/mqdefault.jpg)
Wow..I don't think of it so far, if appsheet can do it, thanks for the information. always success for this channel.
If I want to search for a row by scanning a character using OCR technology, what will be the steps?
Thank you so much man, this will be really helpful.
how would i extract a total price from a receipt. since receipt has multiples number but just need total price?
In this scenario you can assume the highest price is the total price. So max(Extractprices([Column])) something to that effect.
Can you please make a video on how references work in Appsheet…that is bit tricky to understand…thanks
Take a look at this video ruclips.net/video/18N4TpxiwK4/видео.html
Could you give solution for this matter ? Thank you very much if you respond
Data ilustration (3 columns in 1 table)
col.1: A,A,B,C,C,C.........etc
col.2: H,I,J,......... etc
col.3: 1,2,1,1,2,3 (sample data that I want, it is filled automatically),
my question : What is the formula for column 3 to automatically fill in numbers, based on the data in columns 1 and 2 (AH=1,AH=2;BI=1;CJ=1,CJ=2,CJ=3....etc), I know the formula in google sheet (=COUNTIFS($B$2:$B2,$B2)) but don't know in the appsheet, please...thank
Switch() may be the best way.
switch([col1]&[col2], AH, 1, AH, 2, BI, 1, nextcond, nextresult, catchall value)
The first part of the switch function concatenates col A and B. Then follow pairs of conditions and results. Just keep adding on more as needed. The last value is a catch all value if non of the previous pairs match.