Clay Icon

Troubleshooting Formula Issues in Column Matching

·
·

I have to match two columns, and the formula works for any other data, but not for this specific one. Even though the output in the formula is correct, when I click save, the result doesn't work, can u help me please

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This issue could be happening for a couple of reasons: 1. The formula might need iteration or adjustment - it's normal for AI formulas to not give exactly what you're looking for on the first try. You can: • Try adjusting the wording in your formula • Modify the generated code directly • Use the preview feature to verify the results before saving 2. If you're seeing inconsistencies between what's displayed and what's saved, try clearing your browser cache and refreshing your screen, as this could be related to front-end performance issues If the issue persists after trying these solutions, you may want to request human support to look at your specific formula and help troubleshoot the matching logic.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Is that what you were looking for?

  • Avatar of Nathan V.
    Nathan V.
    ·
    ·

    talk to a human

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help.

    If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

  • 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.

  • Avatar of kushagra
    kushagra
    ·
    ·

    maybe just use a merge column for this with

    1. 1.

      ID company match

    2. 2.

      AssociatedCompanyid

    First it will take in all values from 1, then if it is empty it will take in 2. Thinking that should do it.