I currently have a column formula =SUM([\[People\] PM CO Billable(hrs)]:[\[People\] PM CO Billable(hrs)]) to calculate the total number of hours in the column but the first cell is coming back #unparseable even though there was no information in that cell and the rest of the cells in the column are coming back with #BLOCKED. What am I doing wrong?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!