Support Board
Date/Time: Wed, 05 Feb 2025 14:00:36 +0000
Post From: Spreadsheet programming question
| [2020-03-16 13:41:37] |
| Sawtooth - Posts: 4167 |
|
You could use the columns to the right of all study outputs, with these caveats: - If you add any studies, formulas in those columns would be overwritten by study outputs. - Formulas in row 3 will not auto-populate to rows below, as Formula Columns do. IOW, these rows and cells are static. Workaround: If you need more than 60 Formula Columns that auto-populate, you can Duplicate the spreadsheet study on the same chart, and set its 'Chart Data Output Sheet Number' to an unused Sheet#, and use/reference the Formula Columns that will be on that sheet. But there are cautions with this also. If you need a static sheet that is safe from being overwritten, you can add a sheet that is not associated with a chart: Go to Spreadsheet >> Add Sheet and give it a unique name so that it's not confused with a chart's sheet. |