Support Board
Date/Time: Wed, 12 Feb 2025 14:52:38 +0000
Referencing to a cell in a sheet inside a spreadsheet
View Count: 730
| [2020-10-23 16:54:05] |
| User837393 - Posts: 140 |
|
Hello, In a spreadsheet I have two sheets. In one of the sheet I'm trying to reference to a cell from the other sheet, but I'm receiving a syntax error. I used the following link for help : Working with Spreadsheets: References to Other Sheets within a Spreadsheet ...unfortuanately that didn't work. Is there something I need to set in the Study Settings of the spreadsheet to allow that type of referencing ? Best regards |
| [2020-10-23 17:13:58] |
| John - SC Support - Posts: 37891 |
|
That is the correct way to do it, and there is nothing special you need to set in order to do it. One thing that we see that is not in the documentation is that if the sheets you are referencing have spaces, then you need to put the sheet name between single quotes. For example, if you want to reference cell A1 in a sheet named "First Sheet", then you would need to enter this as 'First Sheet'!A1. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-10-23 17:21:28] |
| John - SC Support - Posts: 37891 |
|
Also, make sure you have the correct name of the sheet you are referencing. Check the drop-down in the upper-left corner where you switch between sheets. You need to use the name of the sheet as it is in that drop-down.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: