Support Board
Date/Time: Mon, 16 Mar 2026 23:36:24 +0000
Spreadsheet row 3
View Count: 27
| [2026-03-16 13:32:59] |
| User411320 - Posts: 373 |
|
Hello, How can I input a number in row 3 and then a formula in row 4 of the same column? I'm inputting =0 in row 3 and than =0.2*(K4-K3)+0.8*L3 in row 4 but recalculates to 0 Date Time Of Last Edit: 2026-03-16 13:59:28
|
| [2026-03-16 16:02:49] |
| John - SC Support - Posts: 45139 |
|
For the Spreadsheet studies, you would have to do this in a column that is not a "Formula Column". The Formula Columns are setup special, so what you enter in row 3 of those columns will copy down through the number of rows you have setup for that study. This is because each row represents a bar, so the idea is that you would have a formula in row 3 that would do whatever it needs to do based on the data for each bar. Refer to the following that controls the number of formula columns: Spreadsheet Study Inputs: Number of Formula Columns To put special items into one of these studies, where row 3 is one thing and row 4 is another, then you would need to go to the right of the "Formula Columns" and use one of those columns. You just need to be careful with where you setup the start of the display of other study data in the spreadsheet. You can push these out to the later columns with this Input: Spreadsheet Study Inputs: Blank Columns Before First Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-03-16 19:33:00] |
| User411320 - Posts: 373 |
|
Thanks
|
To post a message in this thread, you need to log in with your Sierra Chart account: