Hi all,
We have a simple calculated field that shows us the date the first update is left on a request. I'd like to modify it to add the time and filter out updates sent from one particular account (we have a 'fusion' wf account that'll sometimes help us with more generic updates.) any recommendations on how best I should modify this to reflect that?
Hi,
Give the following a try:
IF(ISBLANK({DE:First Update Timestamp}),IF({lastUpdatedByID}!="ID OF FUSION ACCOUNT" $$NOW,{DE:First Update Timestamp}),{DE:First Update Timestamp})
In plain English, what is calculation is saying is; If DE:First Update Timestamp is blank then check that the ID of the person who made the last update does not equal the Fusion user ID. If the person who made the last update is not Fusion return a value of NOW, otherwise return the existing value in DE:First Update Timestamp, ELSE if {DE:First Update Timestamp} is not blank return the existing value in {DE:First Update Timestamp}.
I strongly recommend testing this in your preview environment, or in a separate calculated first to make sure it works as expected before updating the live field.
Best Regards,
Rich
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.