HAS_SOME

The HAS_SOME identifier checks if one or more of the specified values are part of the list. It can be used with formula columns, and data input columns (select, multi-select) and returns TRUE or FALSE.

Syntax

has_some(column1, [column2],..., searchvalue1, [searchvalue2],...)

Arguments

column1, column2 - The list of columns where the search needs to be performed. The argument column1 is required and other columns are optional.

searchvalue1, searchvalue2 - The list of values of to search in the columns. The argument searchvalue1 is required and other searchvalues are optional.

Example

Let us consider the below scenario.

The 'Project status' column is created using the data input column of type single select and status is defined for each product. Based on the status, funds are allocated and the expected project completion time is defined.

The 'Fund allocation' column is a data input - number column, which uses the HAS_SOME identifier to search for status and assign funds based on project status.

Using the HAS_SOME identifier

Another formula column is created using HAS_SOME to display the project completion time.

Using the HAS_SOME identifier