I have a date and time data type calculated column named "Date of Review" with the following formula:
Formula explained, if the choice column "Status" has a value other than "Select", the "Date of Review" column will be populated with NOW(), in effect creating a timestamp for when the status was changed.
The problem is any time the record is edited, the "Date of Review" refreshes to NOW().
I understand that you can't use ISBLANK() but I understand I could compare the current value of the column to another.
With that, I created a column "EmptyDate" that is not on any form and is always blank.
What I am trying to do is something like this, but I don't know what I am missing:
=IF([Date Of Review]=[Empty Date],(IF([Status]<>"Select",NOW(),""),"")
I can't get it to work. Any suggestions?