Default values cannot contain references to other columns, so I don't understand how adding a default value would help in my situation. Can you provide an example?

I figured out the necessary syntax to accomplish what I need with a trigger. However, if there is a better way to do it, I'd be glad to try it.