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
There’s no equivalent formula in AppSheet. In AppSheet, adding rows and updating existing rows can be done through Behavior Actions.
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.