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