Support Board

Date/Time: Thu, 25 Apr 2024 02:13:51 +0000

Post From: spreadsheet syntax error

[2019-03-13 01:09:27] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
You are using a Simple Alert syntax on a spreadsheet. The spreadsheet syntax is different. Try this: =C4-D4<=J214 or this: =ID0.SG2@4-ID0.SG3@4<=J214 Notes: - If the result is Boolean (T/F), you don't need to use the IF function. - The current bar is in row 3 and previous bars are in rows below. - When referencing cells in Formula Columns, or in columns A-J, you can use traditional column/row references. - When referencing study output columns, it is best to use this format: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study - SC Engineering might add new system outputs so it is not recommended to use open cells in columns I or J. Column H is open for the user. Date Time Of Last Edit: 2019-03-13 04:26:26