Print Page - Using a cell's value as a sheet ID reference?

Title: Using a cell's value as a sheet ID reference?
Post by: natelfo on April 18, 2019, 08:34:12 PM

I want to have a user defined cell that I can just punch in a number and use the value of that cell as a sheet ID reference in other formulas. For example, If I type in 50, I want other formulas in the shape to reference Sheet.50!. I've tried various things such as =If(Sheet.User.SheetID.Value=50,1,0), and I've tried playing around with adding parentheses, concatenating with the & sign, and no matter what Iv'e tried, I can not get it to work. Any ideas?

Title: Re: Using a cell's value as a sheet ID reference?
Post by: Surrogate on April 19, 2019, 06:09:45 AM

You can use SETF function for create reference. Syntax can be like this

Code Select

SETF(GetRef(<target_cell>),"sheet."&User.id&"!width")short video

Title: Re: Using a cell's value as a sheet ID reference?
Post by: natelfo on April 22, 2019, 06:01:43 PM

Thanks Surrogate. That worked.

Title: Re: Using a cell's value as a sheet ID reference?
Post by: Surrogate on November 15, 2019, 10:26:10 AM

Quote from: Funwbsx on November 15, 2019, 08:44:20 AM
Can you help me?

what kind of consultation do you need?

Title: Re: Using a cell's value as a sheet ID reference?
Post by: Paul Herber on November 15, 2019, 11:40:22 AM

Funwbsx was a spammer that I've just deleted.

Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: natelfo on April 18, 2019, 08:34:12 PM