Support Board
Date/Time: Thu, 28 Nov 2024 14:02:36 +0000
spreadhseet study: add text to cell
View Count: 324
| [2023-05-11 16:51:49] |
| User283743 - Posts: 38 |
|
Ive tried the excel way, using ="ib"&sheet6!DH7 , where ib is the text i want to add to the value from sheet6!DH7. Getting a syntax error. Not sure if sierra supports this or Ive made a mistake in the formula. |
| [2023-05-11 21:25:17] |
| John - SC Support - Posts: 36350 |
|
You would have to use the CONCATENATE() function and when you reference the other sheet, you just use the following syntax: SheetName!Cell So in your example, you would use the following: sheet6!DH7 Therefore, your entry would be the following: =CONCATENATE("ib", sheet6!DH7) Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CONCATENATE_Function 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: