Log date change for multiple choice field
Hello,
I have a form and within there's Data Status field which is multiple choice field with 2 options: Data Incomplete and Data Accepted.
I would like to save separately the date when each of those 2 options is selected.
I created 2 date fields to log those changes: Date Data Accepted and Date Data Incomplete.
I need to log each date change of those 2 fields. When form is saved with Data Incomplete selected then log Date Modified. When form is saved with Data Accepted then log Date Modified BUT keep Data Incomplete date.
I play with following formula but it's not working as it lets me only save the last selected Data Status: If([Data Status]="Data Incomplete", [Date Modified])
Thank you.
I have a form and within there's Data Status field which is multiple choice field with 2 options: Data Incomplete and Data Accepted.
I would like to save separately the date when each of those 2 options is selected.
I created 2 date fields to log those changes: Date Data Accepted and Date Data Incomplete.
I need to log each date change of those 2 fields. When form is saved with Data Incomplete selected then log Date Modified. When form is saved with Data Accepted then log Date Modified BUT keep Data Incomplete date.
I play with following formula but it's not working as it lets me only save the last selected Data Status: If([Data Status]="Data Incomplete", [Date Modified])
Thank you.
