Support Board

Date/Time: Sat, 18 May 2024 04:37:27 +0000

Post From: Spreadsheet programming question

[2021-12-10 01:49:41] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
Can a color bar on alert condition study access a value in spreadsheet cell and use the value within its alert condition? If it cant, what study can be used to get the cell value. Yes, the Color Bar Based On Alert Condition study can reference any subgraph of any of the 3 spreadsheet studies. What this means is that the value must be in one of the Formula Columns K-Z...BR (relative to the Number of Formula Columns setting 16-60, SG1-SG16...SG60). If the cell you want to reference is not in a Formula Column, use a formula like this in row 3 of a Formula Column: =$J$21 Then reference that Formula Column/subgraph SG1-SG16...SG60. If you want to get a value from a spreadsheet Formula Column cell, you can use the Spreadsheet Formula study instead of the color bar study.