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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!