Track date based on choices in multiselect field

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!

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:.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.