Support Board
Date/Time: Tue, 04 Mar 2025 16:15:03 +0000
Post From: Spreadsheet programming question #CREF using Locking the State of a One Time Condition
| [2021-12-12 22:17:06] |
| User183724 - Posts: 191 |
|
Does anyone have a working example of a "Locking the State of a One Time Condition" ? I've tried a thousand combinations and get #CREF every time. I have a 5 minute chart with a BAR NUMBER STUDY. I'm attempting to allow a cell to be updated only once per bar#. If this isnt possible, i'd be ok with some formula using a version of bar time or FRACTIME ...?? where the new bar time allows the cell to update but havent had any luck getting that to work either. basically, i want the cell to only update once per bar. Locking the State of a One Time Condition Spreadsheet Studies Special Tasks |