Support Board
Date/Time: Sat, 14 Feb 2026 22:06:42 +0000
Post From: Spreadsheet latch cell
| [2025-12-29 23:26:53] |
| Sawtooth - Posts: 4313 |
|
If you are going to use the lock TRUE method, test it manually in 3 cells in column H as in my example, not in Formula Columns. This will show you how it is supposed to work. As I said before, automatically resetting it can require trial and error. But first, get it to lock. I still think the persistent variable is most likely your best option. |