Hi All,
Please help me with the complex expression(formula). If anyone is available, kindly drop your email, I’ll add you as a co-author and I’ll share the data source. Thank you
I’m an AppSheet Partner and Developer. You can share with levent@able3ventures.com
Done Levent
i added you already as coauthor and to data dource
LeventK:
the formula under Complexity % in [IPA Questionnaire] table.
=IF(BM2=“TRUE”,(((INDEX(Criteria!$B$10:$C$12,MATCH(‘IPA Questionnaire’!BC2,Criteria!$B$10:$B$12,0),2)Criteria!$C$5)+(BD2Criteria!$C$4)+(INDEX(Criteria!$B$14:$C$18,MATCH(‘IPA Questionnaire’!BL2,Criteria!B14:B18,0),2)*Criteria!$C$7)+(SUMPRODUCT(BG2:BK2,Criteria!F15:J15)*Criteria!$C$6))*1.3), (INDEX(Criteria!$B$10:$C$12,MATCH(‘IPA Questionnaire’!BC2,Criteria!$B$10:$B$12,0),2)Criteria!$C$5)+(BD2Criteria!$C$4)+(INDEX(Criteria!$B$14:$C$18,MATCH(‘IPA Questionnaire’!BL2,Criteria!B14:B18,0),2)*Criteria!$C$7)+(SUMPRODUCT(BG2:BK2,Criteria!F15:J15)*Criteria!$C$6))
thank you in advance
Celes:
=IF(BM2=“TRUE”,(((INDEX(Criteria!$B$10:$C$12,MATCH(‘IPA Questionnaire’!BC2,Criteria!$B$10:$B$12,0),2) Criteria!$C$5)+(BD2 Criteria!$C$4)+(INDEX(Criteria!$B$14:$C$18,MATCH(‘IPA Questionnaire’!BL2,Criteria!B14:B18,0),2)*Criteria!$C$7)+(SUMPRODUCT(BG2:BK2,Criteria!F15:J15)*Criteria!$C$6))*1.3), (INDEX(Criteria!$B$10:$C$12,MATCH(‘IPA Questionnaire’!BC2,Criteria!$B$10:$B$12,0),2) Criteria!$C$5)+(BD2 Criteria!$C$4)+(INDEX(Criteria!$B$14:$C$18,MATCH(‘IPA Questionnaire’!BL2,Criteria!B14:B18,0),2)*Criteria!$C$7)+(SUMPRODUCT(BG2:BK2,Criteria!F15:J15)*Criteria!$C$6))
Is this the sheet formula that you intend to “translate” into an AppFormula in your app?
1 Like
Hi, yes @LeventK
Hi @LeventK, let me know if you need more information about this app. Thank you