If Select option add time

445 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello everyone, 

I'm trying to figure out a formula to use when a selection option is made add the modified time. I know that there is a last modified for when fields are edited by a user. But what I want is when a certain option in a select field is selected to add the time. 

For example user selects, "New Board" from the select field - then the formula would automate the time when the option was selected "4/12/23 4:05pm". 

Thank you!

1 Reply 1

I think you'll need to use an automation for this I'm afraid

1. Create a "Date" field to hold the date time the opion you're monitoring was selected
2. Create a "Last Modified Time" field to and make it reference the select field in question
3. Create an automation that triggers when a record meets a condition, e.g. when the selected option is "New Board"
4. Give it an "Update Record" action to paste the value from the field in step 2 into the field from step 1

This should do what you're looking for!