Skip to main content
Hi,

 

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 respuesta
  1. 27 jun 2011, 16:57
    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.