Clay Icon
Join the Community
02 Support

Using Google Sheet Formula in Clay Tables: Use Cases and Tips

Avatar of Romeo M.Romeo M.
·
·

Hey team, Is there any use case where I can use such google sheet formula in Clay tables? 

=IFERROR(TEXTJOIN(", ", TRUE, FILTER(B$2:B$87, (A$2:A$87=A2) * (B$2:B$87<>B2))), "")

I need to check the data of the whole table. How would you do something like this ?

6 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    While we don't directly support Google Sheets formulas in Clay tables, we offer a powerful alternative: AI-generated formulas. Here's how you can create a similar functionality: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, describe what you want to achieve (e.g., "Join values from column B where column A matches, separated by commas") 3. Click "Generate Formula" 4. Review the sample output and click "Save Formula" This approach allows you to create custom formulas tailored to your needs without directly using Google Sheets syntax. If you need further assistance, please request human help by clicking "Talk to a person".

    Source: Formulas

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, In Clay, everything is handled with formulas too, but formulas work row by row — they don’t automatically scan the entire table like in Google Sheets. If you need to reference multiple rows, you would typically set up a separate lookup or enrichment step. For example, you could pull in related rows based on a shared value and then use a formula to combine or filter the results. Let me know if you want me to walk you through setting it up for your specific case!

  • Avatar of Romeo M.
    Romeo M.
    ·
    ·

    ok, got it, so need ot add it in a different table and basically look it up from there

  • Avatar of Smit V.
    Smit V.
    ·
    ·

    Yes that would work, you can also perform a lookup on the same table you are working in. Let me know if you need any help :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.