Cross sheet reference form limited number of columns

Judith Pappler

Hi group, I am trying to use a formula with a cross sheet reference but when the cross sheet reference form opens i only see about 5 columns of the 50 columns on the reference sheet and the ones i need are not there. I cannot find out what i need to do. Can you help? Thanks, Judith

Andrée Starå

Hi @Judith Pappler

I hope you're well and safe!

Strange!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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 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!

Judith Pappler

ref sheet.jpg

Uploaded Jun 21, 202177.3 KB

Hi Andree,

thanks for your reply! I am attaching a screen shot. Can you see that there is only very few columns available to choose from? The sheet actually has many more.

Thanks!

Andrée Starå

@Judith Pappler

Happy to help!

What happens if you open the sheet from that dialog? Do you see all the columns?

Judith Pappler

Hi Andree,

yes i do but from there i cannot select any columns. but you know what i noticed? That the number of columns shown in the preview were the ones until the first frozen column on the sheet. I unfroze that column and refreshed and now i can see all the columns in the preview! Problem solved :) :) THANK YOU!

Judith

Andrée Starå

@Judith Pappler

Excellent!

You're more than welcome!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!