Is it possible for you to share a screenshot of the specific columns in the formula? I just might need a little more visual context to experiment on my end? I did also want to mention that at this time, it isn’t possible to pull the the autonumber column into the formula column - I am sorry for the setback here
I just wanted to check that you’re using the Autonumber column, correct? If this is the case, I am afraid the column isn’t currently supported in formulas… You would instead need to substitute that column for a numbers column or formula column… which I recognise isn’t ideal.