You need to sign in to do that
Don't have an account?

fomula
How to stamp a date in custom field . i have created a formula field IF( ISPICKVAL(Confirmed__c, 'yes') , today() ,'').
in picklist if yes is selected, today date should populate, when no is selected it should give no value.
Firstly i tried with workflow.created a pickist confirmed__c with yes,no. and date fields as datestamp__c .
when yes is selected i have updated with
Formula Value Today()
when yes is selected iam able to get the date of today. but when i update with NO ,,,, the same date is remains unchanged..
you need to write another workflow with condition no and update the same field with null value.Present your workflow works for only one condition.Its better go with a formula field,instead of workflow.