Welcome to the community, @suhas!
Change your automation to trigger when “record matches conditions” and set it to run when the state field is “done”.
You will also need to create a formula field with this formula:
NOW()
You can hide this formula field so you don’t have to see it.
For your automation action, update the completion date field with the contents of your formula field.
Welcome to the community, @suhas!
Change your automation to trigger when “record matches conditions” and set it to run when the state field is “done”.
You will also need to create a formula field with this formula:
NOW()
You can hide this formula field so you don’t have to see it.
For your automation action, update the completion date field with the contents of your formula field.
this works perfectly, thank you so much!
My only concern with using the NOW()
function is that it won’t necessarily match the precise time of the change. I would suggest using the LAST_MODIFIED_TIME()
function, or make the field a last modified time field. Either way, that timestamp will be more accurate than NOW()
.
^^^ Better idea than mine!! :hugs: