Index/Collect Syntax
Chris Hallo
✭✭✭✭
Good morning, Community! I thought Index/Collect but not 100% on the syntax and could use some help! Seems like I should be able to and if additional helper columns are needed, that can work too.
Where the question mark is below on the APIs sheet, the intent is to bring in how many rows from the Triage_Jira_Export sheet where:
- Get/billing-price-summary is checked
- O/C is Open
- and P/C is Blocker/Emergency
Thanks, everyone :)!.
Best Answer
-
If you want the number of how many rows meet the criteria, you are going to want a COUNTIFS instead.
Answers
-
If you want the number of how many rows meet the criteria, you are going to want a COUNTIFS instead.
-
Makes sense, thanks @Paul Newcome!
-
Happy to help. 👍️
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!