Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 09:49:35 +0000



CLR VERSION SPREADSHEET: SEPERATE SHEET REFERENCING QUESTION

View Count: 1149

[2013-11-28 12:10:05]
enemyspy - Posts: 304
HI here is an example of the formula:

=IF(SHEET11!ID4.SG4.3>0,1,0)

Here is the issue:

If I use the formula on a separate sheet as seen above, it always returns a 0 value.

Whereas the identical formula placed on the the same sheet that contains the study reference returns both 1s and 0s and functions correctly. Is the referencing other sheets within the same spreadsheet supported yet?

thanks again for the help I have recieved in the past.
[2013-11-28 16:39:40]
enemyspy - Posts: 304
nevermind I realized it was the capital letters in the "sheet" portion...I like the new study reference method.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account