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!
Answers

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.

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!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!