If referencing drop-down list

[Nicole Seibert]

Hello fellow helpers,

I wrote the following formula to fill in the direction for a help request
(there are two teams working on the helpdesk) that I thought would fill in
the cell once the corresponding drop-down list was filled in (cell h3). It
is not working. Can anyone tell me why?

=IF(AND(H3="Add New Resource",H3="Update Resource",H3="Project
Rename",H3="Project Check-In",H3="Project Delete",H3="Change Plan
Owner",H3="Request Project Manager Permissions",H3="Request Remote Desktop
Access"),"Send to PRISMhelp",IF(AND(H3="Error Message",H3="Project Workplan
Questions",H3="PWA Time Entry Questions",H3="Resource Center
Questions",H3="Project Center Questions",H3="Portfolio Analyzer
Questions",H3="Cannot access PWA",H3="Cannot access PWA Project
Professional"),"Product Delivery PRISM",""))

[bpeltzer]

You may just need to change the ANDs to ORs; there's no chance that H3="Add
New Resource" AND, at the same time, H3="Update Resource".
--Bruce

"Nicole Seibert" wrote:

> Hello fellow helpers,
>
> I wrote the following formula to fill in the direction for a help request
> (there are two teams working on the helpdesk) that I thought would fill in
> the cell once the corresponding drop-down list was filled in (cell h3). It
> is not working. Can anyone tell me why?
>
> =IF(AND(H3="Add New Resource",H3="Update Resource",H3="Project
> Rename",H3="Project Check-In",H3="Project Delete",H3="Change Plan
> Owner",H3="Request Project Manager Permissions",H3="Request Remote Desktop
> Access"),"Send to PRISMhelp",IF(AND(H3="Error Message",H3="Project Workplan
> Questions",H3="PWA Time Entry Questions",H3="Resource Center
> Questions",H3="Project Center Questions",H3="Portfolio Analyzer
> Questions",H3="Cannot access PWA",H3="Cannot access PWA Project
> Professional"),"Product Delivery PRISM",""))

[Tom Hutchins]

Change AND to OR both places in your formula. You want it to return "Send to
PRIZMhelp" if H3="Add New Resource" OR if H3="Update Resource", etc. Only one
condition can be true at a time for H3.

Hope this helps,

Hutch

"Nicole Seibert" wrote:

> Hello fellow helpers,
>
> I wrote the following formula to fill in the direction for a help request
> (there are two teams working on the helpdesk) that I thought would fill in
> the cell once the corresponding drop-down list was filled in (cell h3). It
> is not working. Can anyone tell me why?
>
> =IF(AND(H3="Add New Resource",H3="Update Resource",H3="Project
> Rename",H3="Project Check-In",H3="Project Delete",H3="Change Plan
> Owner",H3="Request Project Manager Permissions",H3="Request Remote Desktop
> Access"),"Send to PRISMhelp",IF(AND(H3="Error Message",H3="Project Workplan
> Questions",H3="PWA Time Entry Questions",H3="Resource Center
> Questions",H3="Project Center Questions",H3="Portfolio Analyzer
> Questions",H3="Cannot access PWA",H3="Cannot access PWA Project
> Professional"),"Product Delivery PRISM",""))