
I have a status field and a related date and user field.
I need to write a formula as follows, but do not know where to find the sytax rules or if this is possible?
If status1__c has been modified then date1__c =current_date_time and user1__c=current_user
Thank you ... George
답변 1개
If you want to take a value from one field and then change the value on another you are going to need to do this through a Wrokflow rule.
The criteria is
ISCHANGED(Status1__c)
The action are two field updates for the date field put the value as TODAY()
The user put the value as $user.Name.
I hope this helps to clarify.