11183
May 15, 2022, 7:03pm
1
I mean can we optimize complex cascade logic performing by 5–6 If-Then-Else columns by using just one JS column? Because multiple ITE columns decrease performance according to my experience.
Hola!
Your JS code will run on client server (device) and of course, JS helps a lot to save columns and make your APP simpler.
Here an example about what you meant
Hi, guys!
Problem:
I need vanilla SUMIFS from Google Sheets. I need to sum "expenses’ that have certain text attribute and a boolean flag.
Tried solutions:
Rollup with lookup - can’t Rollup on a Lookup column
If-Else-Then’s - can’t have multiple conditions in ITE column.
Hyperofurmulas - they have been removed from Glide.
Formulas in Google sheet itself - looks like Glide cannot parse columns with Google formulas.
Is there a solutions to this? Thanks in advance!
Saludos!
11183
May 15, 2022, 10:16pm
3
Thank you! That’s exactly what I’m looking for.