Copy paste a formula includind reference to another sheet

Julie Barbeau

Hi,

I have a formula with reference to another sheet.

I want to use this formula in a third sheet with exactly the same reference I used in my first sheet but I have this error message : # Invalid Ref

Andrée Starå

Hi Julie,

You have to create the reference on each sheet. It’s connected to each sheet.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Julie Barbeau

Hi André,

How can I do that?

Andrée Starå

Here's an excellent resource.

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets