Does Join/Collect Formulas stay linked when moving sheets?

courtney.d

Does Join/Collect Formulas stay linked when moving sheets? Similar to the Index/Match formula? I need to move a sheet to a new workspace, but don't want the cross sheet formulas to break once I do.

Ray Lindstrom

Hi @courtney.d,

Yes, that will stay intact when moving sheets.

You can always test the theory by making a copy (Save as new) and moving it. That's how I proved it out for myself.

All the best,

-Ray