Recent searches
No recent searches
Periklis P
Joined Jan 22, 2024
·
Last activity Jan 22, 2024
Following
0
Followers
0
Total activity
2
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Periklis P
Periklis P commented,
Is it possible to combine the following formulas?
1. IF (VALUE(First reply time (min)) <= 90) THEN "1:30 hrs" ELIF (VALUE(First reply time (min))>120 AND VALUE(First reply time (min)) <= 60*8) THEN "2-8 hrs" ELIF (VALUE(First reply time (min))>60*8 AND VALUE(First reply time (min)) <= 60*24) THEN "8-24 hrs" ELIF (VALUE(First reply time (min)) > 60*24) THEN ">24 hrs" ELSE " No replies" ENDIF
2. [Ticket created - Day of week],ARRAY("Monday", "Tuesday","Wednesday","Thursday","Friday", "Saturday", "Sunday")
AND IN([Ticket created - Hour],ARRAY(10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
View comment · Posted Jan 22, 2024 · Periklis P
0
Followers
0
Votes
0
Comments