Can you write a case formula where the {entityid} dose not contain ":"

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems you are looking for a formula that checks if the

entityid

does not contain a colon. You can use a

CASE

statement in combination with the

INSTR

function to achieve this. The

INSTR

function returns the position of the first occurrence of a substring in a string, and returns 0 if the substring is not found. Here is a sample formula:

CASE WHEN INSTR({entityid}, ':') = 0 THEN 'TRUE' ELSE 'FALSE' END

This formula will return 'TRUE' if the

entityid

does not contain a colon, and 'FALSE' otherwise. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******