Clay Icon

Formulas Not Working in Table: Need Help Troubleshooting

Β·
Β·

Formulas are not working in our table right now. It is a formula we've used 100x times, and is templated in the table we regularly duplicate. No other changes have been made to it. It's the first step in the table, so we can't do anything until it runs. Not sure how to fix? I've tried deleting and recreating several times. https://app.clay.com/workspaces/12257/workbooks/wb_2oboFGroypsm/tables/t_6MEiDcdcBvi2/views/gv_umyVsXSbNoRe

  • Avatar of Jenna M.
    Jenna M.
    Β·
    Β·

    I included the URL in the post

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey Jenna! Apologies it took so long for us to get back to you! This is unusual behavior for a formula to not work suddenly. Do you have examples of any other tables where this formula was working before and now it is not? I would like to confirm if it is a formula issue (which it most likely is not since it was working) or a platform issue. Sometimes when we copy paste certain formulae they can contain ghost spaces or such that can cause these issues. While you send me an example of a table where this formula was working, I will continue taking a close look at the formula and see if I can make any changes. Let me know! :)

  • Avatar of Jenna M.
    Jenna M.
    Β·
    Β·

    This is the formula used, the locations change table to table, but this formula is templated in this table that we duplicate over and over. I created the first table below the day prior and it worked fine ["LOCATION", "LOCATION", "LOCATION"]?.some(location => {{Search Location Name}}?.toLowerCase()?.includes(location)) https://app.clay.com/workspaces/12257/workbooks/wb_2oboFGroypsm/tables/t_dk6EMQWHDCWp/views/gv_umyVsXSbNoRe https://app.clay.com/workspaces/12257/workbooks/wb_2oboFGroypsm/tables/t_HGNHyCTTimbV/views/gv_pjJhhx2NozAY

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey Jenna! Thankyou for waiting patiently. I copy pasted the formula from one of these two tables that you sent and pasted it in the original table where we are facing this issue. I had to copy paste the states and abbreviations properly and looks like that has solved the issue. Sometimes when we copy paste these formulae and change certain data it can create ghost spaces that interfere with the formula. I have fixed that for you. One way to check this is by keeping only one state (I started with 'United States' as a value and then see if the formula is working. Then copy paste the rest to make sure there are no ghost spaces. Although this is not a method that works every time, it is a good practice to check on a smaller set and then add the whole formula and/or conditions that you may have. I also created a merge column which gives a final checklist by checking for values in both 'enrich location name' and 'search location name'. A merge column is sometimes very useful in merging two formulae columns in one. It allows you to add multiple conditions without complicating the formula too much. Feel free to delete it if it does not suit your use case. Hope this helped and feel free to reach out if you need any more assistance! :)

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·