Using the IF THEN ELSE function

Return to top
Have more questions? Submit a request

34 Comments

  • Robert

    hi 

    how do i get >3 only open tickets based on tag?

    IF (VALUE(Agent replies) =3
    NOT ([Ticket status - Unsorted] = "Hold" OR [Ticket status - Unsorted] = "Solved" OR [Ticket status - Unsorted] ="Closed"))
    THEN [Ticket ID]
    ENDIF

    0
  • Graeme Carmichael
    Community Moderator

    Rahul_N_4009

    I would go for...

    1
  • Robert

    I just want to get open tickets, how do I do that? 

    IF (VALUE(Agent replies) >3AND
    ([Ticket status - Unsorted] = "Open"
    THEN
    [Ticket ID]
    ENDIF

    0
  • Graeme Carmichael
    Community Moderator

    Robert

    Try this...

    1

Please sign in to leave a comment.

Powered by Zendesk