I want to create an app that makes a simple calculation introduced in google sheets.
The idea is to obtein the result varying the different values of the formula.
But I don’t know how to refresh the sheet as a user when a value change and it is related with an other value with a formula.
Is that possible?
Hi David, if I understand it right you want to calculate a result based on a user-specific input?
Can we move the calculation from Sheets to Glide Editor?
In short this can be done multiple ways. If you want the calculation to exist in the sheet you will need to either use forms or have the cell value available for edit and you will have to expect a delay in the response. Your best bet is to use the Glide Editor as ThinhDinh might be suggesting where you’ll see the results instantly.