Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 21:26:26 +0000



CLR VERSION SPREADSHEET: SEPERATE SHEET REFERENCING QUESTION

View Count: 1238

[2013-11-28 12:10:05]
enemyspy - Posts: 306
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: 306
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