How create a fixed date + time field?
I have a field called 'Task completed date' and have the calculated value shown as:
I'd like 'Task completed date' to show the date & time that I change the status to "complete". But if I set the formula as above, whenever I change other fields like descriptions, the time will be updated. How to prevent the time be changed and to be fixed as exactly the time I changed the status?