Formula in google sheet >>>
=IF(G4="";"";IF(M4="";"";IF(S4="";"";IF(S4=โnormalโ;vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G;โแแ แแแกแโ!$B$3:$B = M4); 2; true); 3; true);IF(S4=โsaleโ;vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G;โแแ แแแกแโ!$B$3:$B = M4); 2; true); 4; true);vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G;โแแ แแแกแโ!$B$3:$B = M4); 2; true); 5; true))))))
Warning in appsheet >>>
Column โแแแกแแงแแแ แแ แ. แคแแกแโ of sheet โแแแแ .แแแกแขแ .แแแแแ .โ contains mismatched formulas. Compare the formulas displayed in R1C1 format below to see the differences. 19 rows have MultiColumn formulas. 19 distinct formulas are present of which the first 5 are displayed. 1 rows contain formulas like โIFERROR(__xludf.DUMMYFUNCTION(โIF(G4=โ""","""",IF(M4="""","""",IF(S4="""","""",IF(S4="โnormalโ",vlookup(F4, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M4), 2, true), 3, true),IF(S4="โsaleโ",vlookup(F4, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M4), 2, true), 4, true)"&",vlookup(F4, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M4), 2, true), 5, true))))))"),280.0)โ in A1 format and โIF(RC[-15]="","",IF(RC[-9]="","",IF(RC[-3]="","",IF(RC[-3]=โnormalโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[18]C7,โแแ แแแกแโ!R3C2:R[18]C2 = RC[-9]), 2, true), 3, true),IF(RC[-3]=โsaleโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[18]C7,โแแ แแแกแโ!R3C2:R[18]C2 = RC[-9]), 2, true), 4, true),vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[18]C7,โแแ แแแกแโ!R3C2:R[18]C2 = RC[-9]), 2, true), 5, true))))))โ in R1C1 format including rows 4. 1 rows contain formulas like โIFERROR(__xludf.DUMMYFUNCTION(โIF(G5=โ""","""",IF(M5="""","""",IF(S5="""","""",IF(S5="โnormalโ",vlookup(F5, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M5), 2, true), 3, true),IF(S5="โsaleโ",vlookup(F5, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M5), 2, true), 4, true)"&",vlookup(F5, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M5), 2, true), 5, true))))))"),350.0)โ in A1 format and โIF(RC[-15]="","",IF(RC[-9]="","",IF(RC[-3]="","",IF(RC[-3]=โnormalโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[17]C7,โแแ แแแกแโ!R3C2:R[17]C2 = RC[-9]), 2, true), 3, true),IF(RC[-3]=โsaleโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[17]C7,โแแ แแแกแโ!R3C2:R[17]C2 = RC[-9]), 2, true), 4, true),vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[17]C7,โแแ แแแกแโ!R3C2:R[17]C2 = RC[-9]), 2, true), 5, true))))))โ in R1C1 format including rows 5. 1 rows contain formulas like โIFERROR(__xludf.DUMMYFUNCTION(โIF(G6=โ""","""",IF(M6="""","""",IF(S6="""","""",IF(S6="โnormalโ",vlookup(F6, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M6), 2, true), 3, true),IF(S6="โsaleโ",vlookup(F6, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M6), 2, true), 4, true)"&",vlookup(F6, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M6), 2, true), 5, true))))))"),350.0)โ in A1 format and โIF(RC[-15]="","",IF(RC[-9]="","",IF(RC[-3]="","",IF(RC[-3]=โnormalโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[16]C7,โแแ แแแกแโ!R3C2:R[16]C2 = RC[-9]), 2, true), 3, true),IF(RC[-3]=โsaleโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[16]C7,โแแ แแแกแโ!R3C2:R[16]C2 = RC[-9]), 2, true), 4, true),vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[16]C7,โแแ แแแกแโ!R3C2:R[16]C2 = RC[-9]), 2, true), 5, true))))))โ in R1C1 format including rows 6. 1 rows contain formulas like โIFERROR(__xludf.DUMMYFUNCTION(โIF(G7=โ""","""",IF(M7="""","""",IF(S7="""","""",IF(S7="โnormalโ",vlookup(F7, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M7), 2, true), 3, true),IF(S7="โsaleโ",vlookup(F7, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M7), 2, true), 4, true)"&",vlookup(F7, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M7), 2, true), 5, true))))))"),350.0)โ in A1 format and โIF(RC[-15]="","",IF(RC[-9]="","",IF(RC[-3]="","",IF(RC[-3]=โnormalโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[15]C7,โแแ แแแกแโ!R3C2:R[15]C2 = RC[-9]), 2, true), 3, true),IF(RC[-3]=โsaleโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[15]C7,โแแ แแแกแโ!R3C2:R[15]C2 = RC[-9]), 2, true), 4, true),vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[15]C7,โแแ แแแกแโ!R3C2:R[15]C2 = RC[-9]), 2, true), 5, true))))))โ in R1C1 format including rows 7. 1 rows contain formulas like โIFERROR(__xludf.DUMMYFUNCTION(โIF(G8=โ""","""",IF(M8="""","""",IF(S8="""","""",IF(S8="โnormalโ",vlookup(F8, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M8), 2, true), 3, true),IF(S8="โsaleโ",vlookup(F8, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M8), 2, true), 4, true)"&",vlookup(F8, sort(filter(โแแ แแแกแโ!$C$3:$G22,โแแ แแแกแโ!$B$3:$B22 = M8), 2, true), 5, true))))))"),350.0)โ in A1 format and โIF(RC[-15]="","",IF(RC[-9]="","",IF(RC[-3]="","",IF(RC[-3]=โnormalโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[14]C7,โแแ แแแกแโ!R3C2:R[14]C2 = RC[-9]), 2, true), 3, true),IF(RC[-3]=โsaleโ,vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[14]C7,โแแ แแแกแโ!R3C2:R[14]C2 = RC[-9]), 2, true), 4, true),vlookup(RC[-16], sort(filter(โแแ แแแกแโ!R3C3:R[14]C7,โแแ แแแกแโ!R3C2:R[14]C2 = RC[-9]), 2, true), 5, true))))))โ in R1C1 format including rows 8.
Solved! Go to Solution.
Start by reading this article Mismatched Spreadsheet Formulas
After reading this article I changed the formula part in spreadsheet
old one: =vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G;โแแ แแแกแโ!$B$3:$B = M4); 2; true); 3; true)
new one: =vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G1000;โแแ แแแกแโ!$B$3:$B1000 = M4); 2; true); 3; true)
It helped.
I would reach out to support@appsheet.com about this, that way someone can take a look at your app and give you some direct assistance - unless you already got this figured out. (^_^)
Start by reading this article Mismatched Spreadsheet Formulas
After reading this article I changed the formula part in spreadsheet
old one: =vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G;โแแ แแแกแโ!$B$3:$B = M4); 2; true); 3; true)
new one: =vlookup(F4; sort(filter(โแแ แแแกแโ!$C$3:$G1000;โแแ แแแกแโ!$B$3:$B1000 = M4); 2; true); 3; true)
It helped.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |