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.

Paul Newcome

Try something like this in the [Approved?] column...

 

=IF(AND([APPROVAL Status - BOB]@row = "BOB - APPROVED", [APPROVAL Status - JOEL]@row = "JOEL - APPROVED"), "Approved")

 

and in the [Issue Status] column, this should work...

 

=IF([Approved?]@row = "Approved", "CLOSED")

kwheeler

Thank you!

kwheeler

Thank you!