I am managing a list that requires plain text to be formatted on multiple sheets within one document.
I am referencing a cell on a second sheet by using “=sheet1.a1” This successfully places the content from the referenced cell into the new cell. However, formatting (such as bolding or font color in the original cell) does not carry over to the new cell.
Is there any way to make formatting from the original cell appear in the destination cell, and also to make sure that whenever I make changes to the original cell, the formatting changes carry over to the new cell? I am using version 3.5.7.2.