Spreadsheet formula doesn't appear

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.

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. (^_^)

1 Like

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.

2 Likes