Smartsheet doesn't view known smartsheets im looking to reference?

Morris R

Creating a reference sheet from one Smartsheet to another (looking to create a dashboard in future). However I am trying to vlookup or countif but it doesnt show a sheet that I full admin access. Trying to execute a simple step but cant find these sheets, iI have previously performed these tasks with other sheets.

Thank you in advance!

Morris

Paul Newcome

My suggestion would be to go to the sheet you want to reference itself, copy the name, then paste it in the search bar when doing your lookup.

Paul Newcome

You cannot create cross sheet references from a report. You can only reference sheets. Smartsheet won't even show a report as an option.

Paul Newcome

My suggestion would be to go to the sheet you want to reference itself, copy the name, then paste it in the search bar when doing your lookup.

Morris R

Thank you. I thought it might be title or spelling errors previously. I tried again to make sure.

Another assumption is that i am trying to pull information from a "report" vs "sheet" that is the only other conclusion I can think of that may be blocking me? (Again I am an admin on all of these sheets/reports)

Thank you

Paul Newcome

You cannot create cross sheet references from a report. You can only reference sheets. Smartsheet won't even show a report as an option.

Morris R

Thank you! Most Appreciated

Paul Newcome

Happy to help. 👍️