Strike that – i think i worked it out. Thank you for your insights on this post!

@Jeremy_Oglesby I used your suggested solution and it worked great if there was a number in the old case number field. However, if there’s no value there, it’s not returning my new case number field value in the formula field. Any idea what i’m doing...