Here’s a handy tool to use in Sierra’s spreadsheets: Locking the TRUE state of a formula condition.
This is an expanded explanation of its function, based on Sierra Chart’s documentation:
This is the basic resettable locking state formula:
The colored portions are the only things you edit.
The Red is the cell that contains the entire formula. In this example this formula would go in H3. This creates a return reference to the same H3 cell.
The Blue is the formula that must go TRUE to lock H3 TRUE. It can be as complex as needed, it can be part of this formula, or you can put the formula in another cell and reference it, as in H4 in the example.
The Green is the cell (H5 in this example) that contains the formula to reset the locked state of H3. H5 must be TRUE for H3 to be able to lock TRUE. When H5 goes FALSE, the lock is reset to FALSE. H5 must then go TRUE before H3 can be locked TRUE again.