IF/AND Formula

Options
kwheeler
kwheeler ✭✭
edited 12/09/19 in Formulas and Functions

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!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!