Functions / formulas

Hi there,

I'm trying to amend an existing formula in a column in smartsheet. The formula contains a few different variations. So it's basically, IF "Order Type" is "Renewal", use xx.cc@…, IF Order type is License use CDXX@XXX etc. So it's using specific email contacts when it's a different Order type. What I want to do is for one Order Type - it can be any one of about ten different email addresses. So I want to say if Order Type is Projects use - contact list box. The column that the formula sits in is a contact list format.

Does anyone know how I put this into the formula - what I need to type as in IF("Order Type"), etc?

I really hope this makes sense to someone.

Thanks for any help.

Find more posts tagged with

Accepted answers

All comments

Adam Murphy

Hi @Gina Morrison,

Sorry, I am not sure what you mean by "if Order Type is Projects use - contact list box", but I think what you want to do is to have another column, "Contact List", where you could add multiple contacts as needed, and reference that cell in your formula. So you would have something like IF([Order Type]@row = "Project Use", [Contact List]@row)

Does that help?

Gina Morrison

Thanks for coming back to me. I'm not sure, I might have to get rid of the formulas to make it work for everyone here. thanks again.

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.