Workflow "Alert Someone" | Send to a contact in a cell

Hello Smartsheet Community,

I am trying to create a workflow in Smartsheet using "Alert Someone" that will notify the Manager and Employee (two separate cells) that the specific task has been completed.

Under "Alert someone" I choose "Send to contacts in a cell" however that cell is defaulted to "Created by"….

Questions: Is it possible to change this to any one or more cells other than "Created by"? Or are there any other ways around this?

Open to any ideas 💡

Thank you in advance. 🙂

Find more posts tagged with

Workflows in Smartsheet

triggers

Accepted answers

All comments

Razetto

@Nicolas (Nic) Gonzalez When you select contact is a cell you can select from the various contact columns in your sheet. I'm assuming that your created By is the only contact column available; if you add others they'll be your options.

Nicolas (Nic) Gonzalez

@Razetto Thanks for your answer.

What if your column type is a column: Text/Number?

The column is a free form, therefore the person filling out the form would type their email address. Whatever is in this field, I want the workflow to send an email to this cell.

Razetto

@Nicolas (Nic) Gonzalez You can use a contact column type instead and the person can still enter an email address.

Nicolas (Nic) Gonzalez

@Razetto thank you so much! That was great and worked! Life savor!

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.