This field is to display the "date" value when this Opportunity's Stage value contains "Closed ". and at the same time Opportunity's Stage value not contains Closed means this field needs to be empty/blank. Here Opportunity object Stage field datatype is picklist


Here am getting date value. but when Opportunity's Stage value not contains "Closed" means date field is not empty

  • 1
    Are you trying to create a field to hold the closed date? If yes then you can not use the formula field, you need to have another date field updated with workflow field update or process builder. Jul 22, 2020 at 6:20

1 Answer 1


It's an old question so I don't know if you managed to fix it but you just need to change Null and Today() in your formula :


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .