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.