Support Board
Date/Time: Sun, 22 Dec 2024 19:14:41 +0000
New Spreadsheets INDIRECT function
View Count: 1167
| [2015-03-09 01:49:04] |
| Sawtooth - Posts: 4141 |
|
Would you please add the Excel equivalent of the INDIRECT function to the supported functions of the New Spreadsheets? |
| [2015-03-09 17:12:36] |
| |
|
We will look into this.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-05-03 23:04:52] |
| Sawtooth - Posts: 4141 |
|
Thanks for adding this function, except it gives a #SYNTAX error with this: =INDIRECT("C"&"3") This syntax is needed/used to create a cell reference from 2 text sources. Even using an intermediate cell with this also give a #SYNTAX error: ="C"&"3" Both of the above work in the Old Spreadsheets. Date Time Of Last Edit: 2015-05-03 23:20:10
|
| [2015-05-04 09:02:32] |
| |
|
We will check on this.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2015-05-04 21:59:48] |
| Jeffrey - Posts: 2187 |
|
Use the '+' operator to combine two text values. Example: =INDIRECT("C"+"3") Reference: Spreadsheet Arithmetic Operators |
To post a message in this thread, you need to log in with your Sierra Chart account: