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
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.
Might be best to contact support@appsheet.com directly for help with this.
You can try putting this in the header with something like =ARRAYFORMULA(IF(row(A:A)==1, โColumn Nameโ, โฆ))
I have the same problem. How did you fix it?
=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))
)))))))))
Any solution yet?
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |