You need to sign in to do that
Don't have an account?
Rick 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!
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!
Please try the below formula:
1. Change the Status ==> TEXT(Status)
2. use $User.FirstName + ' ' +$User.LastName to get the changed user.
Thanks,
Maharajan.C