Contact Field

Gaurav Chauhan

Hi Team,

I haven't fully tested by running an alert on the field but was wondering if you can confirm this looks correct. The field type is Contact and need 2 email ids to be populated in this helper column so I can sent an alert to them each time a request gets created.

=IF([Vendor Type (please confirm with vendor)]@row = "Contingent Worker", "abc@amplity.com, 123@amplity.com", "")

The output of the formulae is shown below. Can you please confirm if this the way to hardcode email ids

Paul Newcome

We currently use formulas alone to output multiple usable emails in a single cell.

Here is a thread that has a list of options for getting this finalized for you:

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column