I have a formula working perfectly in the Google Sheet but because of the delay in calculations I need to use the Math Column, however I can’t for the life of me get it to work as calculations in Glide.
I want a user to select an option from 3, for this I’m using the choice component. Based on the response I want a value selected that is then added to another number.
In the Google Sheet I am using IFS to iterate through the choices and present the right number to add.
I have tried using If Then Else and Math but the choice component stops working. Help please!