Help with Index Formula
Hello!
I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the data I need for this one item.
I want to calculate how many strategic projects vs. KTLO projects a team has for the upcoming year. There are nine project types a project could be: 7 of them are strategic, 1 is KTLO and 1 is TBD (it hasn't been labeled yet). I'm referencing our Project Intake sheet which has a column of the Specialist Team and a column for the Project Type.
This is the formula I'm using:
=INDEX(COUNTIFS({2024 Business Planning Database Range 3}, Labels@row, NOT(CONTAINS("TBD", "BAU"))))
The goal is to have a chart that displays how many strategic projects a specialist team has vs. how many BAU/KTLO projects a team has on their docket.
Any help would be appreciated!
Answers
-
You would just use a COUNTIFS. You do not need the INDEX function. Also make sure your COUTNIFS syntax is correct.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!