"To be honest I don't understand why I can't just input a simple formula or have an option to have this happen"

To be fair, you've been offered at least two formula-based solutions, though, since you continue to insist on not using an extra column, I'm not sure exactly where you expect these 'simple' formulae to go.

Regards