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"
When "APPROVAL Status - JOEL" = "JOEL - APPROVED"
"Approved?" column will change to "Approved"
"Issue Status" column will change to "CLOSED"
All 4 of these columns are dropdowns.
Help Article Resources
Check out the Formula Handbook template!