#BLOCKED

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?
Answers
-
What are the actual column names you are using in your sheet?
-
[People] PM CO Billable(hrs) is the column
-
When you are creating your column reference, click and drag a few cells within the column so you end up with something along the lines of
=SUM([\[People\] PM CO Billable(hrs)]1:[\[People\] PM CO Billable(hrs)]5)
And then remove the row numbers. This will ensure the column name reference is definitely correct.
-
When doing this I am still getting a message for a syntax error for a column formula. Why is that?
-
Convert it to a cell formula first. That way we can see what errors pop up and can troubleshoot from there.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!