Forum Discussion
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...
An alternative approach would be to create a PowerApps form and do the calculations in the form and save it back to the list
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.
- 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.
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.