Forum Discussion
ccomins
Jul 02, 2019Copper Contributor
Calculate more than 30 items in a single formula
I have created a sharepoint list for work where I would like to get the SUM of 55 columns, however, it seems sharepoint online does not like formulas with more than 30 items. I have resorted to creat...
Dean_Gross
Jul 02, 2019Silver Contributor
An alternative approach would be to create a PowerApps form and do the calculations in the form and save it back to the list
ccomins
Jul 02, 2019Copper Contributor
Dean_Gross Thank you for your response. This list is actually populated from a PowerApp. The issue with running the calculation in the App is our operations dept wants to be able to edit then data in the SharePoint list directly, which would then need to adjust the calculation.