Array formulas in appsheet

[Chris_Bean1]

Hi there, formula =arrayformula(if(and(MAX(IF($B:$B=$B212,$A:$A))=VALUE($A212),MAX(($B:$B=$B212)*($A:$A=$A212)row($A:$A))=row()),“Y”,“N”))
is in a google sheet.
Appsheet has got this as
=ArrayFormula(if(and(MAX(IF(C2:C2=RC2,C1:C1))=VALUE(RC1),MAX((C2:C2=RC2)(C1:C1=RC1)*row(C1:C1))=row()),“Y”,“N”))
However when new entries are made in the app, the formula does not copy down, and the cell remains blank.

Can anyone recommend any suggestions here? Thanks in advance
Chris

[Kirk_Masden]

I may be confused but I would guess that the array formula should not be in AppSheet at all. The AppSheet code that you quoted would be replicated with every new line. However, you only need one array formula in the spreadsheet – at the first row.

Again, apologies if I have misunderstood your situation.

[Steve]

Might be best to contact support@appsheet.com directly for help with this.

[Bellave_Jayaram]

You can try putting this in the header with something like =ARRAYFORMULA(IF(row(A:A)==1, “Column Name”, …))

[ME_Webdesign]

I have the same problem. How did you fix it?

[ME_Webdesign]

=ARRAYFORMULA(SI(Y(B7=“MONOFASICO”;J7=“Tabla X”); MIN(SI(‘002’!$C$10:$C$29>Q7;‘002’!$C$10:$C$29));
SI(Y(B7=“TRIFASICO”;J7=“Tabla X”); MIN(SI(‘002’!$D$10:$D$29>Q7;‘002’!$D$10:$D$29));
SI(Y(B7=“MONOFASICO”;J7=“Tabla XI”); MIN(SI(‘002’!$G$10:$G$29>Q7;‘002’!$G$10:$G$29));
SI(Y(B7=“TRIFASICO”;J7=“Tabla XI”); MIN(SI(‘002’!$H$10:$H$29>Q7;‘002’!$H$10:$H$29));
SI(Y(B7=“MONOFASICO”;J7=“Tabla XII”); MIN(SI(‘002’!$K$10:$K$29>Q7;‘002’!$K$10:$K$29));
SI(Y(B7=“TRIFASICO”;J7=“Tabla XII”); MIN(SI(‘002’!$L$10:$L$29>Q7;‘002’!$L$10:$L$29));
SI(Y(B7=“MONOFASICO”;J7=“Tabla XIII”); MIN(SI(‘002’!$O$10:$O$29>Q7;‘002’!$O$10:$O$29));
SI(Y(B7=“TRIFASICO”;J7=“Tabla XIII”); MIN(SI(‘002’!$P$10:$P$29>Q7;‘002’!$P$10:$P$29))
)))))))))

[maxmaxmax222]

Any solution yet?