using Formula(text) in a saved search, how do i check if the last two characters of a field are '-X'

AI generated answer (using internal Slack threads):

To check if the last two characters of a field are '-X' using a Formula(text) in a saved search, you can use the

SUBSTR

function in combination with the

LENGTH

function. The

SUBSTR

function is used to extract a substring from a string, and the

LENGTH

function is used to get the length of a string. Here is the formula you can use:

SUBSTR({yourfield}, LENGTH({yourfield}) - 1) = '-X'

Replace

{yourfield}

with the actual field you want to check. This formula will return true if the last two characters of the field are '-X'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******