You need to sign in to do that
Don't have an account?
ArtW
Update Date Field Based on Any Change In My Picklist Values
I'm designing a workflow that should update a Date field with Today's Date, based on each time there is movement on a custom field picklist.
1. Filed 1 Name: Job Status (Picklist)
2. Field 2 Name: Job Status Change (Date Field)
4. Evaluation Criteria Every time a record is created or edited
3. Specify New Field Value Selected: *Use a formula to set the new value
ISCHANGED( SFDC_Job_Status__c, NOW())
Error: Incorrect number of parameters for function ISCHANGED(). Expected 1, received 2
It looks like you're trying to do 2 things at once: Evaluate if the Job Status field has been changed, and set the Job Status Change Date to be TODAY().
These are 2 separate things, you need to make your Trigger Formula
and IF this statement returns a TRUE result then it will initiate a Field Update Workflow Action (this is a totally separate thing). The Field Update Workflow Action is where you want to have your
All Answers
Looks as if you already use the field update in the criteria.
Try
ISCHANGED( SFDC_Job_Status__c)
in the formula, and then in the field update TODAY().
NOW() is a Date/Time function.
Here is what I did:
Field to UpdateProject: Job Status Change
Field Data Type Date
ISCHANGED( SFDC_Job_Status__c, Today ())
It looks like you're trying to do 2 things at once: Evaluate if the Job Status field has been changed, and set the Job Status Change Date to be TODAY().
These are 2 separate things, you need to make your Trigger Formula
and IF this statement returns a TRUE result then it will initiate a Field Update Workflow Action (this is a totally separate thing). The Field Update Workflow Action is where you want to have your
Stevemo ... Thank you very much. That's exactly what I was doing. So simple for you. Hopefully you get paid for this because you're saving quite a few of us quite a bit of TIME!
Thanks Art,
I work gratis, although I do accept these as payment>
http://beeradvocate.com/beer/profile/863/7971
Cheers!
Need your help in my requirement - Users are not using the Stage field,so I want to populate the Opportunity Stage field(Picklist field) with one default value on Opportunity record before click on save button. Other than trigger, Is there other way we can do that?