What do I need to enter for my 2nd criterion range in an index-collect formula?
Hi all,
I'm looking for help with an index-collect formula.
I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range.
Below is the formula I currently have, which I know is incorrect.
Any suggestions?
=INDEX(COLLECT({VENUE}, {PROJECT}, PROJECT@row, ""), 1)
Best Answer
-
SCRATCH THAT! I figured it out.
Answers
-
SCRATCH THAT! I figured it out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!