Cells with IF functions somehow linked


I have 2 columns on sheet A, each with a large IF statement. They both look to fields on sheet B (the same sheet but different fields). For some reason if on field updates, it updates the other field. They are not linked or copied in any way. I've manually rewritten each IF statement more than once.

No matter what I change in 1st Orders Ship from CS or in 1st Orders Arrive at WM DCs, upon save and refresh, they update to be the same formulas. ??



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!