Hi,
I have a complex formula in google sheets. And I need to run it on SmartSuite.
It is haevly going with SUMPRODUCT method of Google Sheets. Is this possible to do this on SmartSuite without if/else?
One of them looks like this and there are 15 of them in one formula:
SUMPRODUCT(--(sum($E334:$I334)>={0,50000,100000,250000,9999999}),sum($E334:$I334)-{{0,50000,100000,250000,9999999}},{0.2,-0.025,-0.025,-0.025,-0}) +SUMPRODUCT(--(sum($J334)>={0,50000,500000,9999999}),sum($J334)-{{0,50000,500000,9999999}},{0.15,-0.05,-0.04,-0})