Hello there
Solved! Go to Solution.
I don't clearly understand what you need to accomplish. Perhaps you need the LOOKUP function.
That said, in case you're not already aware, the sheet you screenshotted is not necessarily structured to be used as a data source for an AppSheet app. Potentially, that's the source of whatever obstacle you're encountering.
Thank for reply.
the screenshot original is just to show how the tipOut is working.
in the Appsheet I already restructured the spreadsheet. My goal is to use the table on the right to find out the right percentage. I’m able to select the number under scenario but I can’t figure how make app sheet go through Am/pm/single/ double
for instance in the in the spread sheet formula I’m using a index (match ()match ()) formula to accomplish the job
THANKY VERY MUCH!!!!
In stead of LOOKUP I used ANY(SELECT()) it work out the same.✌️
User | Count |
---|---|
27 | |
26 | |
23 | |
22 | |
15 |