Auto-Populate Data from Master Sheet Based on Textbook Selection (No Automation)

Hi there! I’m working with a large Smartsheet (30+ columns, 1600+ rows) and need help finding a solution other than automation to auto-populate data. I manage around 300 textbooks, so setting up individual automations isn’t ideal.

Here’s what I’m trying to do:
When a specific textbook is selected in the “Textbook” column, I’d like Smartsheet to automatically pull related data (like ISBN, publisher, etc.) from a master list stored in a separate sheet. Is there a way to do this using formulas or cross-sheet references?

Thanks in advance for any help or suggestions!

Find more posts tagged with

Accepted answers

Gillian C

Hi @SNH

I would use INDEX MATCH or INDEX COLLECT to do this.

Use INDEX MATCH if you are searching one range for a value based on one criteria.

Use INDEX COLLECT if you are searching one range for a value based on two or more criteria.

Some helpful info on both functions here

INDEX Function | Smartsheet Learning Center

Hope this helps, or if you are needing a bit more help just @ me and I'll get the message notification.

Kind Regards

Gillian

All comments

Gillian C

Hi @SNH

I would use INDEX MATCH or INDEX COLLECT to do this.

Use INDEX MATCH if you are searching one range for a value based on one criteria.

Use INDEX COLLECT if you are searching one range for a value based on two or more criteria.

Some helpful info on both functions here

INDEX Function | Smartsheet Learning Center

Hope this helps, or if you are needing a bit more help just @ me and I'll get the message notification.

Kind Regards

Gillian

SNH

Thank you! I used INDEX MATCH, and it worked perfectly. Appreciate the help.

Gillian C

@SNH Super! Glad it helped :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.