Support Board
Date/Time: Fri, 31 Jan 2025 03:05:50 +0000
Post From: lock variable function issue
| [2019-04-06 17:49:36] |
| Sawtooth - Posts: 4164 |
|
The condition you want to lock TRUE needs to be separate and in its own Formula Column, e.g. P3. Then, use this example formula in H3: =AND(OR(H3=TRUE,P3=1),H5). You'll need a separate formula to toggle the H5 portion to reset it for the next lock. (It doesn't need to be in H5.) This is the tricky part because P3 has to go FALSE (it usually does, hence the need to lock it TRUE), and the H5 portion has to toggle to FALSE then back to TRUE. Then reference $H$3 in your other formula that needs this condition to be locked TRUE. |