Clay Icon
Join the Community
02 Support

How to Filter Responses with Red Square Indicators in Excel

Avatar of Pierre L.Pierre L.
·
·

I would like to know how to filter when a response is with a red square - do I have to add a formula each time ?

1 comment

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To filter responses with a red square in Clay, you don't need to add a formula each time. Instead, you can use the Filter List of Objects feature. Here's how: 1. Add a new column and select "Formula" 2. Use the AI Formula Generator to create a filter 3. Reference the column containing the red square indicator using "/" 4. Click "Generate Formula" and review the sample output 5. Save the formula This will create a reusable filter for red square responses. If you need to apply this filter to different datasets, you can use the Filter List of Objects action, specifying the relevant field and filter criteria. If you need more help with this process, please request human assistance by clicking on "Talk to a person".