2 of 2 people found this helpful
In 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