IF formula help please
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
-
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
-
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))))
-
Thank you Hollie, I copied your formula and I'm still receiving an error #unparseable
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!