Clay Icon

Formula Column Issues in Excel: Cut Off After 65 Rows

·
·

I'm having similar issues to Sofia C. above. I have a simple formula column that should easily run and it's on an existing table that I've had no issues with before. (In fact, I have multiple similar tables in the same workbook and they are all experiencing the same issue). There are a 2340 rows to run (based on current filters) but it keeps cutting offer after 65 or 197 rows. The formula is to cut down text from a linkedin description. I've tried to edit the column by changing the 400 to 401 just to see if it would trigger but it keeps getting stuck. I've also added a new column with similar functionality and that keeps cutting out at the same point as well. I've pasted the link the workbook below: https://app.clay.com/workspaces/89103/workbooks/wb_ZiBh4hxJpRRc/tables/t_V3Es5uhB8Pfq/views/gv_6y4M4SjxBgQG

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    It sounds like you're experiencing performance issues with your Clay workbook. This can happen with large tables or complex workflows, especially when multiple actions are running simultaneously. The issue may be causing latency, where cell data takes longer to load or process. To troubleshoot: 1. Try a hard refresh: • Mac: Command (⌘) + Shift + R (Chrome/Firefox) or Option (⌥) + Command (⌘) + E (Safari) • Windows: Ctrl + F5 or Ctrl + Shift + R 2. Clear your cache and refresh your screen. If the problem persists, it might be a short-term front-end performance issue. If you need further assistance, please request human support by clicking on "Talk to a person" in this chat.

  • Avatar of Brian O.
    Brian O.
    ·
    ·

    I've done the hard refresh and cleared the Chrome cache.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Brian, I took a look at your table, and the rows do have values—so it’s possible you might’ve edited them since. Also, when scrolling quickly through large tables, some rows can take a bit longer to load, which can make it seem like data is missing. If you pause for a moment, the rest should catch up and display properly. Let me know if you’re still seeing gaps after that—I’m here to help.

    (183 kB)
    Image
  • 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.