Can you use sheets formulas as “app formulas”?
In my sheet I can select a name from a drop down and the following formula shows data based on the dropdown choice. Can I accomplish the same thing via Appsheet? Can I have the view show a drop down and based on that choice show information based on that choice? Here is my sheets formula:
=(QUERY(Sheet2!Z3:AD,“Select Z,AA,AB,((AD-AC)*24)/.25 label Z’Funder’,AA ‘Client’,AB ‘Service Date’,((AD-AC)*24)/.25 ‘Units Used’”,0))
Any advice is appreciated.