IF/AND Formula

kwheeler

I am trying to create a formula for when two approval columns have 'Approved' in their dropdowns to change two other dropdown columns.

When "APPROVAL Status - BOB" = "BOB - APPROVED"

AND

When "APPROVAL Status - JOEL" = "JOEL - APPROVED"

THEN

"Approved?" column will change to "Approved"

AND

"Issue Status" column will change to "CLOSED"

All 4 of these columns are dropdowns.

 

Thank you!

Es

In your Approved field enter something like this:

=IF(AND([Bob column] = "approved", [Joel column] = "approved"), "approved")

i.e. if Bob's and Joel's fields = "approved" then set Approved field to "approved."

Since Approved? and Issue Status will always be equal, in Issue Status field enter:

=[Approved?]

i.e. set the value of this Issue Status field = Approved? field.