LinkedIn
Twitter
I've setup an email distribution set on the area an item of data is submitted. The only problem now is that there are more areas being added all the time so the slices to select the distribution list for the areas is getting larger.
Lets say, submitted Data is called "Test data" and [Area] = "TES"
Email Distribution data with fields [Email Address]=(PII Removed by Staff), [Area] contains "TES", [Test Data?]="Yes"
So when a submission is made, and it is for area TES, I want the "To" to perform a lookup to see who it should be sending the email to without the need to create Slices for each Area.
AND(LOOKUP("Yes", "Email List", "Test Data?", "Email Address"), but not sure what to put for it to see which AREA contains "TES" within the Email Distribution Data.
