Autofit Problems with a Row that includes a formula referencing another cell

I have a document that I created that has merged cells. In order to autofit the rows of this document, I referenced the merged cells in singular cells that are not visible to the users of the document. (They are not hidden)

It had been working relatively nicely, but now the autofit function is not working correctly. If I copy and paste values into the cell it will work, but this would not be my ideal solution.

Any suggestions? I have tried playing with the number format, which works for the most part if I set it to "&" - text. It doesn't work for some longer cells with line breaks in them.

Re: Autofit Problems with a Row that includes a formula referencing another cell

I set them to the same column width. They are set to wrap text. For some reason it is just not working. I think I'm going to have to just copy and paste values on an ongoing basis as these files are updated every 2 weeks. Not that big of a deal I guess.

Centering across columns is not an option as this is a form that is filled out by others.