Index/Collect Formula

Brittanyy

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

Paul Newcome

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

Paul Newcome

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