Using index/collect formula from another smartsheet

I am trying to use index/collect to enter an email address located in another sheet.

Source Sheet is Database Macro_2025:

Target Sheet is Delinquency Report: Using 75033 as the example from the Source Sheet. I need the email for the Accountant of Customer ID 75033 to be entered in the Finance Contact Column AND General Manager in the Alternate Contact Column.

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @Victoria Ganuelas,

You need 2 need to formulas.

Finance Contact: =INDEX(COLLECT({E-Mail Address}, {Property Number}, [Customer ID]@row , {Position}, "Accountant"), 1)

Alternat Contact: =INDEX(COLLECT({E-Mail Address}, {Property Number}, [Customer ID]@row , {Position}, "General Manager"), 1)

Make sure to create the cross-sheet references for the email, property number, and postion.

Hope this helps,

Dave

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.