IF formula help please

Options

I have one column that has a drop down of 3 choices and based on the answer I want to list information in another column. Like if they select "Submitter of this form" I want it to return the information in the "Submitters email" column.

Getting an error and can't see what it is;

=IF([Site specifics]@row, = “Submitter of this form”, ([Submitters email]@row], IF([Site specifics]@row = “Site coordinator “, [Site Coordinator email address], IF([Site specifics]@row = “Day of event coordinator“, [Day of event point of contact email address]))))

Help please??

Best Answer

  • Connie Cochran
    Connie Cochran ✭✭✭✭
    Answer ✓
    Options

    Was able to figure it out. It should be

    =IF([Site specifics]@row = "Submitter of this form", [Submitters email]@row, IF([Site specifics]@row = "Site coordinator", [Site Coordinator email address]@row, IF([Site specifics]@row = "Day of event coordinator", [Day of event point of contact email address]@row, "")))

Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Options

    You were missing a couple of @rows try the below

    =IF([Site specifics]@row, = “Submitter of this form”, ([Submitters email]@row], IF([Site specifics]@row = “Site coordinator “, [Site Coordinator email address]@row, IF([Site specifics]@row = “Day of event coordinator“, [Day of event point of contact email address]@row))))

  • Connie Cochran
    Connie Cochran ✭✭✭✭
    Options

    Thank you Hollie, I copied your formula and I'm still receiving an error #unparseable



  • Connie Cochran
    Connie Cochran ✭✭✭✭
    Answer ✓
    Options

    Was able to figure it out. It should be

    =IF([Site specifics]@row = "Submitter of this form", [Submitters email]@row, IF([Site specifics]@row = "Site coordinator", [Site Coordinator email address]@row, IF([Site specifics]@row = "Day of event coordinator", [Day of event point of contact email address]@row, "")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!