+ Start a Discussion
Abhijeet Purohit01Abhijeet 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?

Suresh RaghuramSuresh Raghuram

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

Abhijeet Purohit01Abhijeet Purohit01

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.

kamlesh_chauhankamlesh_chauhan

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.