Budget Sheet YTD Sum formula help
Options
jinden@wchealth
✭✭✭
I'm building a sheet for a department who wants to track monthly revenue/expenses and have those numbers roll into YTD columns. (moving them into Smartsheets and out of Excel)
Each month has 2 columns Actual & Budget, i want to set up a formula so when numbers are entered into respective monthly cells the YTD cell auto-updates.
I've tried SUM([column1name]:[column3name]:[column5name]) which is how im reading the help article but i'm getting #UNPARSEABLE in my cell.
Thanks!
Comments
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!