Hi, I’m trying to lock in a timestamp when a status changes to one particular status. I would like that timestamp to be locked in and not change once the status changes to the next stage.
Here’s a formula that would work except that once the status ...
So, do I understand you correctly that there is a single status field with 9 different choices? Let’s say
STATUS can be RED, ORANGE, YELLOW, GREEN, BLUE, PURPLE, VIOLET, CYAN, or MAGENTA.
DATE1 records date/time when the status becomes RED
DATE2 rec...
So, what I ended up doing was using check boxes. When the box is checked, it adds to a counter which changes the status. The checkbox is then tied to a “date modified” field which marks the time when the status was changed. I have a checkbox for e...
