Formula - Cross Sheet Referencing

alwayslearning

Hi Community,

I’m trying to cross-sheet reference. After I type the start of the formula, the box to “Reference Another Sheet” appears. I clicked it, found my sheet, chose the column, but the “Insert Reference” box remains grey. I’m the owner of both sheets. What am I missing? Screenshots attached. Thank you!

Andrée Starå

@alwayslearning

Yes, the name should have been added automatically, so that's strange as well.

Have you tried to log out/in again? Seems like a glitch.

Did that work?

Andrée Starå

Hi @alwayslearning

Try naming the Reference.

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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

alwayslearning

1. I did try that, but it didn't work. I read this in the learning center: "Optional: In the Sheet reference name text box, type a name for your reference. If you don’t enter a name, the reference will be assigned a default name based on the sheet name and the number of times that sheet has been referenced."

Andrée Starå

@alwayslearning

Yes, the name should have been added automatically, so that's strange as well.

Have you tried to log out/in again? Seems like a glitch.

Did that work?

alwayslearning

Logging out and rebooting worked. I automatically assumed it was me. Thank you Andrée!

Andrée Starå

@alwayslearning

Excellent!

You're more than welcome!