Jul 02 2019 04:14 PM
Jul 02 2019 04:14 PM
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.
Jul 02 2019 04:36 PM
Jul 02 2019 04:46 PM
@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.
Jul 02 2019 05:43 PM
Jul 04 2019 03:50 AM
Jul 04 2019 08:07 AM
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.
Jul 04 2019 08:12 AM - edited Jul 04 2019 08:15 AM
@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.
Aug 21 2023 09:55 AM
I have hit the wall several times. They at least could tell you when it errors out. No, you lose all your data and keep fighting. @ccomins
Aug 22 2023 04:31 AM
So, you can use the nested SUM functions or the SUM function with addition ( + ) like:
In 1st nested SUM() you can use [Col1] to [Col30] and 2nd nested SUM() you can use [Col31] to [Col55].
In 1st SUM() you can use [Col1] to [Col30] and 2nd SUM() you can use [Col31] to [Col55].
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.