How do I connect a cell in one sheet with a cell in another sheet?
I am not sure what you mean by “connect”. But here’s an example of how you reference to a cell from another sheet:
# A1 (from sheet1) + B1 (from Sheet2)
=$Sheet1.A1+$Sheet2.B1
Thanks, Markus.
I stumbled on this method: type ‘=’ in home cell; then tap cell to be referenced in second sheet. That generates your formula. However, it is unreliable, failing even when the manually entered formula works. I did not work out the restriction.