Linking contacts from sheet A to sheet B

I am trying to connect contacts from Sheet A to a workflow automated message from a form in Sheet B. Is something like this possible?

Sheet A is a database of people listing names, skills, locations, emails, etc. Sheet B is fed by a form, I would like new rows to trigger a workflow to send an automatic message to a subset of the people in Sheet A based on the criteria that are chosen in the form. How can I connect the contacts from Sheet A to sheet B? Is there an alternative workaround for this? It seems that I can only choose contacts for the Sheet B workflow from Sheet B, but it doesn't make sense to co-mingle the people data with the message request data onto a single sheet.

Find more posts tagged with

Forms

Contacts

Automations

Workflows in Smartsheet

Accepted answers

All comments

Andrée Starå

Hi @LizTo

I hope you're well and safe!

Yes, you can "connect" them by using cross-sheet formulas and have them trigger a time-based workflow.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

LizTo

Hi @Andrée Starå , thank you for the response!

I think I understand. Are you suggesting adding another column to Sheet B, that would have a cross-sheet formula importing the relevant contacts from Sheet A?

Which formula is the best to use in this case, COLLECT?

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.