Anyone know how to apply a DGET function and ...

references
(Vernelle Kruse) #1

Anyone know how to apply a DGET function and INDEX + ARRAY function so that it does the same formula on appsheet? I have a working sheet that I use but want to transition it to a mobile for to add-on onto my app.

(Tony Fader) #2

@Vernelle_Kruse1 You may want to use SELECT, LOOKUP, and reference columns.

https://www.appsheet.com/samples/This-app-shows-how-to-do-SUMIFs-and-COUNTIFs-in-AppSheet?appGuidString=22f56e42-2079-4ef5-8780-22c469762700

https://www.appsheet.com/samples/How-to-use-the-LOOKUP-function?appGuidString=18f54bdc-9d6d-46b8-b063-419a8340da16

https://help.appsheet.com/data/references/references-between-tables

https://www.appsheet.com/samples/A-basic-demo-of-table-references?appGuidString=6ffad040-b04a-4325-aa73-ace5df8ba1b5