You need to sign in to do that
Don't have an account?
Abhijeet Purohit01
Problem with workflow
I am writing a workflow which should trigger an email when following conditions are satisfied:
Status of a picklist field is not changed for 7days OR Status of the text field is not changed for 7days.
This is the formula that I have framed:
AND( NOT(ISCHANGED(Brand__c)), NOT(ISCHANGED(Comment__c)), IF((Last_Field_Change__c =Last_Field_Change__c+7),TRUE,FALSE ))
Can anybody help me?
Last_Field_Change__c what is its data type
and refer this link you may get some idea
http://na12.salesforce.com/help/doc/en/workflow_time_action_considerations.htm
Here, Brand__c is a picklist field, Comment__c is a text field and Last_Field_Change__c is a date/time field which stores LastModified Date/Time of Brand__c or Comment__c.
Abhijeet,
Try below formula.
AND( NOT(ISCHANGED(Brand__c)), NOT(ISCHANGED(Comment__c)), IF((Last_Field_Change__c+7 <=TODAY()),TRUE,FALSE ))
I have modified your formual little bit.
Regards,
Kamlesh Chauhan, (Founder & CTO)
LogicRain Technologies, (Salesforce and Force.com Development Division)
Cellular: +91-(997) 476-6800 Office: (732) 676-6400 Skype:kamlesh.logicrain
kamlesh@logicrain.com || http://www.logicrain.com || LinkedIn
Answers/Suggestions are my own.
If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.