This content has been marked as final.
Show 1 reply
-
1. Re: Target End Date in 3 Hours
Noah Genin Feb 11, 2019 2:45 PM (in response to Noah Genin)2 of 2 people found this helpfulIn case anyone needs this in the future here is the formula to get a true/false for "target end date is in 3 hours"
We are using this on quickviews so that all tickets due in 3 hours turn orange. This helps our staff quickly prioritize which tickets they should be looking at.
IF(((BMCServiceDesk__TargetEndDate__c - NOW())*24) <= 3, "true", "false")
I then referenced this formula field on the incident object using a formula text field
SLA_Status_Lookup__r.Target_End_Date_in_3_Hours__c