Skip to main content
Web Applications

Return to Question

Tweeted twitter.com/StackWebApps/status/695757273495400449
added 81 characters in body
Source Link
Luis Queral
Luis Queral
  • 33
  • 5

I have a specific task that I believe might require some kind of custom script.

Here is (a copy) of the spreadsheet in question: https://goo.gl/d2P778https://docs.google.com/spreadsheets/d/1fwk-I3VHIeQP4AC4J-vQB8vbuM3YONgCfTTSrDSNhz8/edit#gid=850165930

This spreadsheet is a template for designing the content model of a piece of software. As such, users will be copying the Sheet entitled "---" depending on the configuration of their project.

My question refers to Column C across all of these pages, entitled "Bound Values". I need some way for all variables within this column (across all pages) to be printed within a single column on a hidden sheet (represented by the sheet titled "🌴").

End Goal

Whenever editing cells in the "Bound Values" column, I would like to have the option of selecting previously used variables within this column across other pages.

I can currently only do this by referencing a single, static sheet that I would need to manually update (which is time consuming).

Another way of looking at it

I would use this on the hidden sheet to scrape all cell values across all pages in column C:

[![example screenshot][1]][1] [1]: https://i.sstatic.net/v9OBI.png .

My Questions Are:

  • How might one be able to do this in Google Sheets, if at all?
  • If not, how might a script be structured to achieve this?

I have a specific task that I believe might require some kind of custom script.

Here is (a copy) of the spreadsheet in question: https://goo.gl/d2P778

This spreadsheet is a template for designing the content model of a piece of software. As such, users will be copying the Sheet entitled "---" depending on the configuration of their project.

My question refers to Column C across all of these pages, entitled "Bound Values". I need some way for all variables within this column (across all pages) to be printed within a single column on a hidden sheet (represented by the sheet titled "🌴").

End Goal

Whenever editing cells in the "Bound Values" column, I would like to have the option of selecting previously used variables within this column across other pages.

I can currently only do this by referencing a single, static sheet that I would need to manually update (which is time consuming).

Another way of looking at it

I would use this on the hidden sheet to scrape all cell values across all pages in column C:

[![example screenshot][1]][1] [1]: https://i.sstatic.net/v9OBI.png .

My Questions Are:

  • How might one be able to do this in Google Sheets, if at all?
  • If not, how might a script be structured to achieve this?

I have a specific task that I believe might require some kind of custom script.

Here is (a copy) of the spreadsheet in question: https://docs.google.com/spreadsheets/d/1fwk-I3VHIeQP4AC4J-vQB8vbuM3YONgCfTTSrDSNhz8/edit#gid=850165930

This spreadsheet is a template for designing the content model of a piece of software. As such, users will be copying the Sheet entitled "---" depending on the configuration of their project.

My question refers to Column C across all of these pages, entitled "Bound Values". I need some way for all variables within this column (across all pages) to be printed within a single column on a hidden sheet (represented by the sheet titled "🌴").

End Goal

Whenever editing cells in the "Bound Values" column, I would like to have the option of selecting previously used variables within this column across other pages.

I can currently only do this by referencing a single, static sheet that I would need to manually update (which is time consuming).

Another way of looking at it

I would use this on the hidden sheet to scrape all cell values across all pages in column C:

[![example screenshot][1]][1] [1]: https://i.sstatic.net/v9OBI.png .

My Questions Are:

  • How might one be able to do this in Google Sheets, if at all?
  • If not, how might a script be structured to achieve this?
Source Link
Luis Queral
Luis Queral
  • 33
  • 5

How do I create a data validation function to print the values of a specified column across all pages?

I have a specific task that I believe might require some kind of custom script.

Here is (a copy) of the spreadsheet in question: https://goo.gl/d2P778

This spreadsheet is a template for designing the content model of a piece of software. As such, users will be copying the Sheet entitled "---" depending on the configuration of their project.

My question refers to Column C across all of these pages, entitled "Bound Values". I need some way for all variables within this column (across all pages) to be printed within a single column on a hidden sheet (represented by the sheet titled "🌴").

End Goal

Whenever editing cells in the "Bound Values" column, I would like to have the option of selecting previously used variables within this column across other pages.

I can currently only do this by referencing a single, static sheet that I would need to manually update (which is time consuming).

Another way of looking at it

I would use this on the hidden sheet to scrape all cell values across all pages in column C:

[![example screenshot][1]][1] [1]: https://i.sstatic.net/v9OBI.png .

My Questions Are:

  • How might one be able to do this in Google Sheets, if at all?
  • If not, how might a script be structured to achieve this?