Support Board
Date/Time: Fri, 31 Jan 2025 03:10:50 +0000
Post From: lock variable function issue
| [2019-04-05 23:10:48] |
| Sawtooth - Posts: 4164 |
|
If you are using this concept...: https://www.sawtoothtrade.com/example-9.html Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition ...then the locked cell should be in a static cell (e.g., column H or row 1) not in a Formula Column. Then reference the locking cell in another formula. Locking and unlocking a locking cell with formulas can be tricky because of the need to alternate to FALSE, then to TRUE, to set up the next lock. You might need to separate each portion in separate Formula Columns to isolate the trouble. |