Home >> Support Board

Support Board

Date/Time: Thu, 18 Apr 2024 19:21:02 +0000

How to Post a Message for Support

[User Discussion] - Spreadsheet Formula in Row 2 keeps disappearing

View Count: 582

[2021-01-12 18:11:54] #1 [Go To First Post]
j4ytr4der_ - Posts: 912
I'm creating a nested formula in a Spreadsheet System for Trading that will display the name of my various setups, if the criteria for them is present, so that I can then display that on a chart to call my attention to it. It works just fine since I can display the label from Row 2 on a chart, but periodically the whole formula just disappears and Row 2 resets back to being a letter, losing my work. I can't find any particular pattern or action that causes this, it just happens randomly and is really giving me headaches. Anyone know why this happens and how to prevent it?

[2021-01-12 19:49:02] #2 [Go To First Post]
j4ytr4der_ - Posts: 912
So I don't even have to be doing anything. I just walked away from my desk for lunch, came back and the formula in Row 2 is gone. So there is some sort of automatic "reset" happening somehow. Additionally, any time I manually recalculate the spreadsheet, the formula disappears. Date Time Of Last Edit: 2021-01-12 19:51:11

[2021-03-23 20:35:02] #3 [Go To First Post]
j4ytr4der_ - Posts: 912
BTW turns out this happens if the formula evaluates to an error in column 2. It will reset back to the letter the column originally had. Confusing and weird but there it is.

[2021-03-23 20:54:02] #4 [Go To First Post]
bradh - Posts: 853
Not sure what you are trying to do, but formulas should not go in row 2. They go in row 3, and then they are automatically filled down as many rows as the study settings uses.

[2021-03-23 23:33:07] #5 [Go To First Post]
j4ytr4der_ - Posts: 912
Formulas can go in row 2, in fact it is the only way you can display a text label on a chart from a spreadsheet. Whatever is in row 2, becomes the name label and can easily be displayed. I use it quite a lot and it's fantastically useful.

[2021-03-23 23:55:53] #6 [Go To First Post]
bradh - Posts: 853
Good to know. Thanks.

[2021-03-24 11:58:17] #7 [Go To First Post]
Sawtooth - Posts: 3973
Here are some examples: Using the Spreadsheet Study: Using a Formula in Formula Columns Row 2

[2021-03-24 17:43:58] #8 [Go To First Post]
j4ytr4der_ - Posts: 912
Yep and that documents exactly what I figured out on my own eventually... "If the result of the formula is not a text value, but a number, error, empty value, or something else, the formula will be replaced with the default name of the column."

To post a message in this thread, you need to log in with your Sierra Chart account: