I have a Google Sheet set up so that a new row is added with the results each time an employee completes a review in another application. Columns C through H are number values, and I want to sum them for each individual row. So my formula for I2 (row 1 being a header) is =SUM(C2:H2). I want each row to sum automatically when it is added.
I cannot just drag the formula down because any content in the new row breaks the automation that is pulling in the data. I've tried mucking around with ARRAYFORMULA, but it isn't working (probably my fault), and frankly, I'm out of my depth.