Help with Sheet Summary Formula
What I am trying to do:
I am trying to write a formula that counts the projects that are in any of the following Stage of Project: Kick-off & Requirements Gathering, Test Setup, UAT, or Deployment AND the Type of Project is Maintenance - Break Fix.
Formula I am using:
=COUNTIFS([Stage of Project], "Kick-off & Requirements Gathering", [Type of Project], "Maintenance - Break Fix") + COUNTIFS([Stage of Project], "Test Setup", [Type of Project], "Maintenance - Break Fix") + COUNTIFS([Stage of Project], "UAT", [Type of Project], "Maintenance - Break Fix") + COUNTIFS([Stage of Project], "Deployment", [Type of Project], "Maintenance - Break Fix")
Getting a #UNPARSEABLE error.
Any suggestions on what the issue is? Or how to fix it?
Answers
-
Try:
=COUNTIFS({Stage of Project}, OR(@cell = "Kick-off & Requirements Gathering", @cell = "Test Setup", @cell = "UAT", @cell = "Deployment"), {Type of Project}, "Maintenance - Break Fix"
-
Hi @Kblake,
Are the columns you are looking at on the same sheet or a cross sheet reference? If these are a cross sheet reference, the square brackets should be curly brackets e.g. {Stage of Project}.
If these are on the same sheet, the column needs to be qualified further e.g. [Stage of Project]:[Stage of Project].
Hope this helps.
Dave
-
Thank you, both. The columns are within the same sheet. I tried the formula @Nic Larsen provided, that gave me an #INVALID REF error.
I will play around with Dave provided to see if I can get it to work. I got an #UNPARSEABLE error, but will go back and double check I don't have an error somewhere.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!