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


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!