I have an existing workflow formula that reads:

Date_of_Event__c  - CloseDate > 30

I would like to add a criteria that checks if the closed opportunity was marked 'Closed won' so that its not firing for all the closed lost opportunities.


1 Answer 1


You can check against the IsWon field.

AND(IsWon, Date_of_Event__c - CloseDate > 30)

You could also check IsClosed if you want to be sure you only fire for Closed/Won records:

AND(IsClosed, IsWon, Date_of_Event__c - CloseDate > 30)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.