Hello everyone, fascinated by all the stuff we can do with appsheet. However I believe I have hit a wall in my project.
I am in the process of creating a technical analysis appsheet for financial markets. In my spreadsheet I have the option to use a dropdown menu that allows me to choose whether I want my calculations to give me the result for the current day or 1,2,3,4 & 5 days prior.
If letโs say I choose 5 days ago option. My formulas will reference a cell which values just changed to 5 based on the dropdown option.
My question for the group is:
Will I be able to add such functionality to the app whereas the app user can use a dropdown to chose whether he/she wants to see current day results or results from prior 5 days?
Thank you in advance for any help you can provide
FX_Baba
Yes, a good place to retain that is in the user settings
For any expression that depends on this dropdown option, you can maybe use a SWITCH expression.
SWITCH([dropdown] ,
โ1โ , expression for one day ,
โ2โ , expression for two days,
etcโฆ
)
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |