Support Board
Date/Time: Fri, 07 Feb 2025 15:21:05 +0000
Post From: Spreadsheet programming question
| [2021-12-10 01:49:41] |
| Sawtooth - Posts: 4173 |
|
Can a color bar on alert condition study access a value in spreadsheet cell and use the value within its alert condition?
Yes, the Color Bar Based On Alert Condition study can reference any subgraph of any of the 3 spreadsheet studies.If it cant, what study can be used to get the cell value. 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. |