Calculate more than 30 items in a single formula

Highlighted
Occasional Contributor

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 creating columns at the end of every section, calculating the sum of sections separately and then combining those total columns into a final total at the end. I would like to be able to do this with a single column/formula. Is this possible or is there a better way? 

 

I have looked into flow, but haven't figured out how to accomplish this there either.

 

I have searched but haven't found any info pertaining to this issue. I cant imagine I am the only one trying to calculate 30+ columns.

 

Thank you in advance.

6 Replies
Highlighted
An alternative approach would be to create a PowerApps form and do the calculations in the form and save it back to the list
Highlighted

@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. 

Highlighted
How about giving the ops dept an edit form in the app that is tailored for their needs, this would keep all of the business logic in one place and therefore provide more accuracy.
Highlighted

@ccomins 

 

Maybe this helps: https://youtu.be/5GVYio9NKkw

I haven't tried it with the amount of columns you're talking about. 

I'm curious if there is a limit. 

 

Kind Regards

 

 

 

Make it possible to see Totals by letting a flow calculate sums instead of using the SharePoint calculated column: https://www.kalmstrom.com/Tips/SharePoint-...
Highlighted

 I will certainly keep that in mind. The app is still being developed, once that is complete I will look at implementing an edit form just for Ops. In the mean time I will just create a separate view for ops in the sharepoint list that will hide all the muck.

Highlighted

@SmetsDavy Thank you for your response. I have seen that video before and tested the process. As far as I can tell the add expression in flow can only add TWO items at once. I am new when it comes to flow, so if i am incorrect on that, please let me know. I would love to use flow to calculate the total columns, I just haven't found a way.