Creating sum in a column for a day

Dear community

Struggling with this problem - tried already different approaches but was not successful.

I want to create a sum of values per day in a table and then an overall sum. How can I get only one sum per day, like in the column "Result I want"?

Thank you very much.

Best regards



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!