Clay Icon
Join the Community
01 Community General

Segmenting Job Titles by Function in Clay: A Guide

Avatar of Mukund G.Mukund G.
·
·

i have a list which has mix of all the job titles, how can i segment that list by job function in clay

2 comments

  • Avatar of Summiya B.
    Summiya B.
    ·
    ·

    You can use formula to extract the job titles. IF( OR(CONTAINS([Job Title], "Marketing"), CONTAINS([Job Title], "Brand"), CONTAINS([Job Title], "Growth")), "Marketing", IF( OR(CONTAINS([Job Title], "Operations"), CONTAINS([Job Title], "Logistics"), CONTAINS([Job Title], "Supply Chain")), "Operations", "Other" ) ) After categorization shift them into multiple tables

  • Avatar of Mukund G.
    Mukund G.
    ·
    ·

    got it, thanks