Login Page - Create Account

Support Board


Date/Time: Sun, 12 May 2024 12:20:05 +0000



Post From: Spreadsheet, formula including all session bars

[2024-03-24 18:15:54]
User440951 - Posts: 40
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 ?