Replace Multiple Values with Multiple Values

MLK

I have a Status column which is a dropdown list. I would like a formula that checks the Status column and returns a different number for each item in the list. Any suggestions on how to do this?

STATUS. RETURNED VALUE

"NA". "1"

"Not Started". "2"

"Priors Pending" "3"

and so forth.....

Anjanesh Vaidya

Hi MLK,

You can try the below formula-

=IF(Status@row = "NA", 1, IF(Status@row = "Not Started", 2, IF(Status@row = "Priors Pending", 3, "")))

Thank You!

Anjanesh Vaidya

Anjanesh Vaidya

Hi MLK,

You can try the below formula-

=IF(Status@row = "NA", 1, IF(Status@row = "Not Started", 2, IF(Status@row = "Priors Pending", 3, "")))

Thank You!

Anjanesh Vaidya

MLK

@Anjanesh Vaidya Perfect. Thanks!!!