Support Board

Date/Time: Mon, 25 Nov 2024 04:29:24 +0000

Post From: Spreadsheet Study - Referencing a spreadsheet cell vs Study Name and Subgraph

[2024-04-02 15:44:33] Link To Thread - Link To Post [Go To First Post]
User337568 - Posts: 60
Using Spreadsheet Study Goal Replacing cell references with Study references. This formula works: =IF(E3>AD3,1,IF(E3<AE3,-1,0)) This generates a #Name Error. =IF(ID0.SG4>ID3.SG4,1,IF(ID0.SG4<ID3.SG5,-1,0)) Troubleshooting: ID0.SG4 - Close - good ID3.SG4 - Study in chart & valid Id3.SG5 - Study in Chart and Valid I asked CoPilot to check, and it said the Sierra Chart Syntax is okay and go check if the references are valid and in the chart. However, cell references work, while study references do not.