Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 10 Jan 2025 13:21:33 +0000

How to Post a Message for Support

Post From: Shortcut for Alert Requiring Multipe Prior Bars in MAX Formula

[2016-09-06 21:47:21]
[Go To First Post]
Sawtooth - Posts: 4147
The syntax for Simple Alerts is different than for spreadsheets:
The current bar in Simple Alerts is referenced:
=ID22.SG1[0] where the [0] is optional for 0 only.
The current bar in a spreadsheet is referenced:
=ID22.SG1@3 where 3 is row 3.

So the spreadsheet formula would be:
=MAX(ID22.SG1@3:ID22.SG1@22)
Date Time Of Last Edit: 2016-09-06 21:47:40