If / Contains combination

Rebecca Menning

Just recently, we have been experiencing automated workflow messages triggered based on formulas that are years old 😯 It appears that these messages are triggering each time a user sorts the originating sheet a different way. In an attempt to debug the issue, I found the below. Any thoughts as to why the destination Smartsheet is showing a location of 3?

Thanks

Becky Menning

Rebecca Menning

Just a step further

When I resort the source sheet….. the correct location shows on the destination sheet