Track date based on choices in multiselect field

[Vicki_Vainshtei]

I have a table with a multiselect field for stages: Submitted, Reviewed, Approved, Completed. I would like to track the date of each stage change in separate fields. So Date Submitted, Date Reviewed, Date Approved, Date Completed. I used the Last Modified Date field type, but it overwrites each time the stage is changed and that does not work for our needs. Any suggestions?

Thank you!

[Rose_K · Accepted solution]

Hello and welcome @Vicki_Vainshtein!

You can accomplish what you are looking to do by converting your Single Select field into different checkboxes for each status. With the checkboxes in place, you can then create a formula field to track when each box was checked:

Here is the formula:

// you would do this for each checkbox field
IF({Reviewed}, NOW())

Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .