I have one formula field that watches another field for a particular value like ‘Started task’ and will mark a timestamp when it sees it. I have another formula field watching for ‘Done task’. The problem is that when I change status from ‘Started task’ to ‘Done task’ in the watched field, my ‘Started task’ date disappears. I wish there was a way in a formula to do something like ‘compute only the first time you see this’, so that it sticks for all time.
Sure, I could manually enter the date, but that’s not why I love Air Table :slightly_smiling_face: