Support Board
Date/Time: Thu, 23 Jan 2025 09:35:05 +0000
Post From: Spread Sheet formula to establish if the sheet is presently being outputted to from chart
| [2018-11-13 01:29:35] |
| enemyspy - Posts: 306 |
|
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
|