Support Board
Date/Time: Mon, 25 Nov 2024 07:43:01 +0000
Post From: Spreadsheet, formula including all session bars
| [2024-03-24 18:15:54] |
| User440951 - Posts: 50 |
|
I worked on the subject, it was complicated but I think something happened. I was able to create my persistent variables in columns in this form : =IF(CROSSFROMABOVE(ID0.SG3@3:ID0.SG3@4,ID2.SG3@3:ID2.SG3@4),1,AQ4) And I was able to modify my plots when the conditions are true with this formula in another column : =IF(AQ3=1,(ID2.SG13@3-((ID2.SG13@3-ID2.SG3@3)*0.236)),(ID2.SG13@3-((ID2.SG13@3-L3)*0.236))) On the other hand, I have concerns about persistent variables which set me to true when it should be false. I think it comes from the fact that it doesn't take into account the session only. You say "- Once the formulas return values, use another spreadsheet column to limit their display to the session times" How can I do this ? Is this a formula that will impact all persistent variables ? |