function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rick RossiRick Rossi 

Activity Formula Question

Hi! 

I am trying to do a workflow field update VIA formula. The premise is when the task "status" field is changed I want to track the date and time of when it was changed and what user changed it. I am running into issues getting the user part into the formula and the error messages when trying to save my formula:

Error Message: Error: Field Status is a picklist field. Picklist fields are only supported in certain

Formula:

Date_Time_Status_Change__c  &
IF(NOT ISBLANK(Date_Time_Status_Change__c ), BR(), '') & 
TEXT(NOW()) + ' - ' +  Status

Any input would be great thank you!
Maharajan CMaharajan C
Hi Rick,

Please try the below formula:

1. Change the Status  ==> TEXT(Status)
2. use  $User.FirstName + ' ' +$User.LastName  to get the changed user.  
  
Date_Time_Status_Change__c &
IF(NOT ISBLANK(Date_Time_Status_Change__c), BR(), '') & 
TEXT(NOW()) + ' - ' +  TEXT(Status) + BR() + $User.FirstName + ' ' +$User.LastName

Thanks,
Maharajan.C
 
afds fdsgfafds fdsgf
Yes you can visit on the link here (https://warringtonremoval.co.uk/) to see some best formula categories that are very usable for this purpose.