Author Topic: Using a cell's value as a sheet ID reference?  (Read 2464 times)

0 Members and 1 Guest are viewing this topic.

natelfo

  • Newbie
  • *
  • Posts: 6
Using a cell's value as a sheet ID reference?
« on: April 18, 2019, 03: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?

Surrogate

  • Hero Member
  • *****
  • Posts: 1029
    • ShapeSheet™ Knowledge Base
Re: Using a cell's value as a sheet ID reference?
« Reply #1 on: April 19, 2019, 01:09:45 AM »
You can use SETF function for create reference. Syntax can be like this
Code
SETF(GetRef(<target_cell>),"sheet."&User.id&"!width")
short video
« Last Edit: April 19, 2019, 03:10:54 AM by Surrogate »

natelfo

  • Newbie
  • *
  • Posts: 6
Re: Using a cell's value as a sheet ID reference?
« Reply #2 on: April 22, 2019, 01:01:43 PM »
Thanks Surrogate.  That worked.

Surrogate

  • Hero Member
  • *****
  • Posts: 1029
    • ShapeSheet™ Knowledge Base
Re: Using a cell's value as a sheet ID reference?
« Reply #3 on: November 15, 2019, 05:26:10 AM »
Can you help me?
what kind of consultation do you need?

Paul Herber

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2947
    • Paul Herber's website
Re: Using a cell's value as a sheet ID reference?
« Reply #4 on: November 15, 2019, 06:40:22 AM »
Funwbsx was a spammer that I've just deleted.
Electronic and Electrical engineering, business and software stencils and applications for Visio -

https://www.paulherber.co.uk/