Functions / formulas

Gina Morrison

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.

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.