Index/Collect Formula
Hi there, I need assistance on Indexing/ pulling names from our directory on Smartsheet that reach a certain criteria.
Formula I have: INDEX(COLLECT({DS-Name}, {DS-Office}, [Office@row], {DS-Title}, [Title@row]), 1
Example: I want to Index/collect a name that is from the "Austin" Office and contains the title "Office Administration"
Master Sheet:
Reference Sheet below:
References:
DS-Name: Name Column
DS-Office: Office Column
DS-Title: Title Column
I want to pull index/collect John Doe’s name into the Office Admins column on the master sheet
Best Answer
-
Try removing the [square brackets] from around the column names. Square brackets only wrap around the name (not the @row portion) and only when there is at least one space, number, and/or special character in the column name.
ColumnName@row
[Column Name]@row
[Column1]@row
Answers
-
Try removing the [square brackets] from around the column names. Square brackets only wrap around the name (not the @row portion) and only when there is at least one space, number, and/or special character in the column name.
ColumnName@row
[Column Name]@row
[Column1]@row
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!