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 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.
Please Help - Formulas and Dates
Hello, I am trying to create a column that would take a date from one cell and add 9 Months and 1 Day, therefore returning a date of 9 months and 1 day later. My issue is, while using the normal date on 31/12/2020 and 05/04/2020 dates, I get 02/10/2021 (wrong) and 06/04/2021 (right) dates. I need the date to be exactly 9 months and 1 day post the above dates but can not find a way to have it shown. Please help. My formula atmo - =IF(QIPS?>0,"N/A - QIPS",DATE(YEAR([Year end])+0,MONTH([Year end])+9,DAY([Year end])+1))
