Appsheet formula (Array)

[maxmaxmax222]

Hi all,

Can anyone translate the below google sheet formula to appsheet formula? Appsheet is not automatically generate the formula for me when the new entry is created.

ArrayFormula(INDEX('Importrange_Work Status'!$D$2:$D$4000,(MAX((AB3='Importrange_Work Status'!$G$2:$G$4000)*ROW('Importrange_Work Status'!$D$2:$D$4000)))-1))

Thank you very much for you help

[Joseph_Seddik]

There's no equivalent formula in AppSheet. In AppSheet, adding rows and updating existing rows can be done through Behavior Actions. 

[Aurelien]

Hi @maxmaxmax222 

You may want to have a look to this useful post:

https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216

If you provide more context and screenshot, we can help you with an expression suggestion.