How can I fix my sum formula ranged whenever I have new inputs from Forms?


Hi, I have sheets where I am collecting the data using the form. I have setup my form to put new submitted data at the top of my table. My problem is , when new submitted data was collected the range of my formula is being changed and not getting the new collected data. See the Total formula.

Please help me to fix the range of my SUM formula or there is another way to do it?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!