Formula to Expression

[MitzvaTank]

How to I convert such formula from Google Sheets to an AppSheet expression

'MAXIFS($A$4:$A,$B$4:$B,"<>"&"")+1'

[Marc_Dillon]

https://help.appsheet.com/en/articles/2357296-max

https://help.appsheet.com/en/articles/2357314-select

[Swoopy · Accepted solution]

Try

MAX(
   SELECT( tableName[columnA], ISNOTBLANK([columnB]) )
) + 1

This returns a number so it'd be suitable for being in column's initial expression or view's display-name expression.

[MitzvaTank]

THANKS, IT WORKS