if statement based on another column

Melanie Sanders

Hello All,

I am trying to figure out the best way to create an if statement. In my column RML Status if the status is RML-Current or In-TRL Current I would like my helper column to state ACTIVE. If it doesn't have either of these two status', I would like it to state INACTIVE. How would I go about creating this the simplest way?

WMS

I think you'd need a nested IF statement:

=IF([RML STATUS]@row = "RML-Current", "ACTIVE", IF([RML STATUS]@row = "IN-TRL", "ACTIVE", "INACTIVE"))

WMS

I think you'd need a nested IF statement:

=IF([RML STATUS]@row = "RML-Current", "ACTIVE", IF([RML STATUS]@row = "IN-TRL", "ACTIVE", "INACTIVE"))

Melanie Sanders

@WMS Thank you!!!