Hi everyone! first time posting here, I’ve read many posts already and they have been very useful but I need guidance about this issue.
I’m creating an app that makes a nutritional plan according to the user, they send their details through a form and can edit whenever they want.
I have a sheet that calculates their caloric needs and according to that needs creates a plan to lose weight, maintain or gain weight.
Problem is: through the google sheet I’ve made it so far using many IFS formulas (choosing either to lose weight, gain weight, maintain and the nutritional plan they want -there are three kinds-) on top of that in regards to which week the user is in (plans last 8 weeks), the app through another big big IFS decides which image to show.
I don’t know if it’s because of connection lag or too many calcs to resolve before the apps shows results but the user feeling is terrible, it takes about 10s to update the data and maybe more than a minute to show the image. I started doing with math columns (which show data instantly) via data editor but I need sooo many columns that I have the feeling that this must have a better solution. What do you guys think?