Support Board
Date/Time: Tue, 11 Mar 2025 16:45:00 +0000
Post From: Add a study to spread sheet and have to recode everything
| [2022-04-22 02:33:47] |
| Sawtooth - Posts: 4182 |
|
Do I really have to rewrite the logic every time I add or remove a study to the spread sheet??
Not if you do one of these:1. Use this method of referencing study outputs instead of the alphanumeric column/row reference: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 2. Add all studies at the bottom of the list in the Studies to Graph list, and never remove or rearrange any study in the list, and never insert or delete a Formula Column. Option 1 is preferred because: - You can add, remove, rearrange studies in the Studies to Graph list without messing with formulas. - You can insert and delete Formula Columns without messing with formulas. Date Time Of Last Edit: 2022-04-22 22:04:48
|