I have Invalid ref with this code
=COUNTIFS({Generic - Parent Row}, 0, {Generic - NA}, 0, {Generic - Status}, <>"Blue", {Generic - % Complete}, <>1, {Generic - Task Name}, <>" ", {Generic - Task State}, <>"On Hold", {Generic - Finish Date}, <$Date$1)
I have a metadata sheet that has everything in it. I dont know much about it but I am looking for start date delays & past due dates/ If needed, I can post the project plan
Wayne
Answers
-
How are you creating your cross sheet references?
You should be clicking on the link that says "reference another sheet" in the "helper" dialog box that appears when you are typing inside of a function. Once you click on that link a new window will open that allows you to first select your sheet then select your range (click on column header to reference entire column). Then you can click on the "insert reference" button in the bottom right of that window to create the cross sheet reference.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!