Need Field that Shows When Status Field was Last Updated

733 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to figure out how to create a field that will update every time the "CLIENT STATUS" field is changed and maybe another field that says how many days that record has been in that status. Any ideas? Thanks!

3 Replies 3
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey there!
For the first field request, on getting a field that will update everytime the "CLIENT STATUS" is changed you can use the field type Last Modified Time and select the specific field. This will update the timestamp with the last modification on the selected field


You can set up a formula field maybe called "time_in_status" that uses the field explained above and the following formula


You can also use TODAY() instead of NOW(). Only note about this formula field is that it will reset everytime the client/record changes status. So if you'd like to keep historical track of the days in status, you would need up to set up some status timestamp scheme

4 - Data Explorer
4 - Data Explorer

I have no idea I face this issue in my honda civic multi media screen.


Better use the TODAY() function, as it request less load.