Record a date based on when the question was asked

[Roger_Wareham]

I have a question with 4 options (only one option can be select at time)

1. In-progress
2. Trained
3. Certified
4. Delayed

I have 2 date columns to record the day that Trained was selected and Certified selected.

I have an if formula but it records the date when you select one and then when you select the other one the first date removes.

I want to record when the user selects Trained and when the user goes back and selects Certified it records that date but also leaves the trained date as the original date when it was selected.

I don't want the user to have to fill in these dates but automatically fill in based on the progress.

The user on the question can only select one at a time, as it's coming from the Ref sheet.

Please let me know if you can help with this problem.

THanks 

[Aurelien · Accepted solution]

Hi @Roger_Wareham 

Did you consider using ChangeTimeStamp columns ?

You may want to have as many ChangeTimeStamp columns as you have status possibilities.

Track changes using Change column types