Displaying a symbol in a column based on the combination of values in two other columns

Shari D

Hi,

I am trying to figure out how to display a symbol based on the values of the Result column and the Status column as follows:

Is there a way to accomplish this with a formula or do I need to use reference sheets?

Thanks!

Carson Penticuff

Well... yes it can be done... but those are quite a few conditions. Try this:

=IF([Result]@row = "", IF(OR([Status]@row = "", [Status]@row = "Not Started", [Status]@row = "In Progress", [Status]@row = "Complete"), "", IF([Status]@row = "Delayed", "Hold", IF([Status]@row = "Rollback", "No"))), IF([Result]@row = "Fail", IF(OR([Status]@row = "", [Status]@row = "Not Started", [Status]@row = "In Progress", [Status]@row = "Delayed"), "Hold", IF(OR([Status]@row = "Complete", [Status]@row = "Rollback"), "No")), IF([Result]@row = "Success", IF(OR([Status]@row = "", [Status]@row = "Not Started", [Status]@row = "In Progress", [Status]@row = "Delayed"), "Hold", IF([Status]@row = "Complete", "Yes", IF([Status]@row = "Rollback", "No"))))))

Carson Penticuff

Well... yes it can be done... but those are quite a few conditions. Try this:

=IF([Result]@row = "", IF(OR([Status]@row = "", [Status]@row = "Not Started", [Status]@row = "In Progress", [Status]@row = "Complete"), "", IF([Status]@row = "Delayed", "Hold", IF([Status]@row = "Rollback", "No"))), IF([Result]@row = "Fail", IF(OR([Status]@row = "", [Status]@row = "Not Started", [Status]@row = "In Progress", [Status]@row = "Delayed"), "Hold", IF(OR([Status]@row = "Complete", [Status]@row = "Rollback"), "No")), IF([Result]@row = "Success", IF(OR([Status]@row = "", [Status]@row = "Not Started", [Status]@row = "In Progress", [Status]@row = "Delayed"), "Hold", IF([Status]@row = "Complete", "Yes", IF([Status]@row = "Rollback", "No"))))))

Shari D

It works beautifully! You are a genius! Thank you!

Carson Penticuff

I'm glad I could help!