+ Start a Discussion

Update a Date Formula Field when a Pick List is a Certain Value

I want to update a custom field (Date Passed) to the Date when the Lead Status is changed to "Passed to Partner".

If the Lead Status is anything else, the field would be blank.

What would the formula be to do this?

I know this is wrong, but would it be something like

IF( ISPICKVAL( Status, "Passed to Partner", TODAY(), )

Thank you

Best Answer chosen by Admin (Salesforce Developers)

Georgia2
I figured it out in case anyone else is looking for this
IF(ISPICKVAL(Status, "Passed to Partner"), TODAY(), null)

Need an account? Sign Up

Have an account? Sign In