Recent searches


No recent searches

Nestor Vergano's Avatar

Nestor Vergano

Joined Jul 13, 2023

·

Last activity Dec 29, 2023

Following

0

Followers

0

Total activity

6

Vote

1

Subscriptions

3

ACTIVITY OVERVIEW

Latest activity by Nestor Vergano

Nestor Vergano commented,

CommentWriting formulas

Hi!

I'm trying to identify those tickets that had been received before the end of the the day (Mon-Fri before 18:00) BUT had been left over (from New to Open) till the next day.

This is the script I wrote, but an error "There's an issue with the formula..." appears with no more precise info. The highlighted code is the one that brings the formula error, and I don't understand why.

Please Help! Thanks in advance

IF (IN([Ticket created - Day of week],ARRAY("Monday", "Tuesday","Wednesday","Thursday","Friday"))
    AND IN([Ticket created - Hour],ARRAY(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)))
THEN IF ([Ticket created - Date] != [Ticket first assigned - Date])
            THEN TRUE
            ELSE FALSE
ELSE FALSE
ENDIF

View comment · Posted Dec 29, 2023 · Nestor Vergano

0

Followers

0

Votes

0

Comments


Nestor Vergano created a post,

Post Español Comunidad

Hola, Cuento con una suscripción Professional y necesito ayuda para poder configurar un reporte de Explore que me muestre todos los tickets recibidos en horario laboral (New) pero que no fueron tomados por un agente hasta el día siguiente.
Muchas gracias.

Posted Dec 27, 2023 · Nestor Vergano

0

Followers

2

Votes

1

Comment