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