When a Formula reference a dropdown choice?

[FX_Baba]

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

[Grant_Stead]

Yes, a good place to retain that is in the user settings

[Marc_Dillon]

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…
)