Customized Column // Transform product names into categories

Hi Anonymous ,

Try formula like below:

Conditional =
IF (
    Data[Products combined] = BLANK (),
    BLANK (),
    IF (
        Data[Products combined] = "Product A,Product B",
        "Project A including Project B",
        IF (
            CONTAINSSTRING ( Data[Products combined], "X" )
                || CONTAINSSTRING ( Data[Products combined], "Y" )
                || CONTAINSSTRING ( Data[Products combined], "F" ),
            Data[Products combined],
            IF (
                (
                    LEN ( Data[Products combined] )
                        - LEN ( SUBSTITUTE ( Data[Products combined], ",", "" ) )
                ) >= 1,
                "Solution Project",
                Data[Products combined]
            )
        )
    )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.