Category / Section
How to create a custom expression condition with list of values?
Published:
When working with custom expressions and lists, you may want to create a conditional expression that checks if a certain value is present in a list. In this example, we will be using a list of statuses (Open, In_progress, Completed, etc.) and creating an expression to determine if a status should be archived or kept.
Creating the Expression
To create a custom expression that checks if a value is in a list, you can use the following format:
IF([Status]='IN_PROGRESS' OR [Status]='OPEN' OR [Status]='COMPLETED', 'to_archive', 'keep')
This expression checks if the value of `Status` is equal to 'IN_PROGRESS', 'PAID', or 'DELAY'. If it matches any of these values, the expression will return 'to_archive'. If it does not match any of these values, it will return 'keep'.
RM
