Support Board

Date/Time: Sun, 28 Apr 2024 08:20:56 +0000

Post From: Spread Sheet formula to establish if the sheet is presently being outputted to from chart

[2018-11-13 01:29:35] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
I have a spreadsheet study with multiple sheets for several charts at once. A static sheet uses all the sheets in the spreadsheet study to display certain data. I want to make a way to ignore data that comes from sheets in the study that are presently not connected to a chart. Since a chart # that does not exist in the study creates a sheet, and the sheet stays put when you open the study in a new chart book whether linked to a chart or not: It would be useful to establish if the sheet is linked to a chart. I thought this could possibly be done by checking for changes in one of the J cells when replaying or connected to data feed since the data does not change if not linked. I was unable to succeed at making a formula that can do that though. Has anyone ever been able to make a formula to establish if a sheet is linked to a chart? If so would you care to share? Date Time Of Last Edit: 2018-11-13 01:31:19