Not sure why I cant get this to work? TIA for any guidance!

Executive Alchemist

Need assist on another formula:

=IF(CONTAINS(Tier@row, 3), "ME", IF([Independent Reviewer]@row = "ME"), "AH", IF(CONTAINS(Tier@row, 4), "SM", IF([28. Assurance Project PIC]@row = "SM"), "JL"))

I am getting an error: "#CIRCULAR REFERENCE". 

Again, any help is greatly appreciated!

Eric Law

https://community.smartsheet.com/discussion/114439/not-sure-why-i-cant-get-this-to-work-tia-for-any-guidance

What column are you putting this in? Circular reference means you are using the cell that the formula is posted in, or you are using a cell that another cell is using to sort the formula. Please post a screenshot with a follow up if that isn't what the problem is.

Executive Alchemist

Here is a snip:

I am writing this in the "Independent Reviewer" column. If "Tier" is "3", want to return "ME", if #28 is "ME", then return "AH".

If "Tier" is "4", want to return "SM", if #28 is "SM", then return "JL".

Also, if "Tier" is "NA", want to leave blank.

Thanks for any help!