Cell reference character limit

[jstn07s]

Working on an uploadable spreadsheet that translates info entered on one sheet to another. The comments field column on sheet 2 is formulated as =TEXT('Sheet1'!CellX, "")

The comments are being referenced, but there seems to be a character limit, as longer ones are generating a #VALUE! error.

Any help, alternative formulas , etc. is much appreciated. Thanks!

 

[Asala42]

Looks like you are correct - there's a 255 character limit.

Could you just get away with:
=if(len('Sheet1'!CellX)>255,'Sheet1'!CellX,text('Sheet1'!CellX,""))

 

[jstn07s]

Thanks for this. Was trying to tool around with an IF formula but couldn't get it exactly right. Of course I can rely on a fellow Michigander for help.