Auto set the date that a status change happens

[Pedro_Wunderlich]

Working on a sweet CRM. I’d like to populate a column with the exact date that status changes to either “Deal Closed” or “Deal Lost”. Not sure how to achieve this…

Appreciate the help guys!!

[Jean_Pierre_Traets]

Dear @Pedro_Wunderlich,

This should do the trick:

[Pch]

I’ve done this a very little bit “differently” (Not really but kind of ) … Depending of the results you want

Note that if you want to change the Status , you’ll need to adapt the formula in Close/Lost too

[Jean_Pierre_Traets]

Dear @Pch
Great input

[Pedro_Wunderlich]

Wow! @Jean_Pierre_Traets @Pch, I’ve never seen such a helpful community!! Thank you so much you two for the prompt replies. Great ideas!

[Pch]

Always glad to help when I can !