Issue with Company Normalization Column Auto-Recalculating in Spreadsheet

Andi Deng · 2025-01-05 22:48:44.637008+00

Hey team, my "company normalization" column keeps on re-run itself every time I make updates on other columns... Any idea what's happening here?

Issue with Company Normalization Column Auto-Recalculating in Spreadsheet | Clay

11 comments

· Sorted by Oldest

Channeled
APP
·
·
This is happening because auto-update is enabled on your table. When auto-update is on, your table automatically runs all columns whenever rows are added or edited.To stop the company normalization column from re-running, you can turn off auto-update by: 1. Clicking the Auto-update icon at the bottom right of your table 2. Selecting "Turn Off Table"Alternatively, you can configure the company normalization column to run only under specific conditions by using formulas that trigger the column when certain criteria are met. Sources: Clay formatters overview | Documentation | Clay University Configuring your table settings | Documentation | Clay University Auto-update and Auto-dedupe Table
Andi Deng
·
·
will Clay table run on the cloud if I close the tabs?
Channeled
APP
·
·
Clay tables don't automatically run enrichments on a schedule when you close your tabs. The only exception is for tables with CRM sources, which update through a two-way sync every 24 hours. Source: Can I schedule data enrichments so they re-run on their own? - FAQ | Clay.com
Channeled
APP
·
·
I'm glad I could help! I'm here if you have any more questions.
Channeled
APP
·
·
Hi Andi Deng! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Andi Deng
·
·
if I refresh the table, would it interrupt all the columns that are running?
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Andi Deng
·
·
if I refresh the table, would it interrupt all the columns that are running?
Channeled
APP
·
·
Yes, refreshing the table can interrupt columns that are currently running. When columns are running in a waterfall setup, they process data sequentially, and refreshing the page would disrupt this process. If you need to preserve your data while making changes, it's recommended to wait until the current enrichments are complete before refreshing. Source: Enrich People (Waterfalls) [Clay 101] - Clay University
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.
Andi Deng
·
·
If I add in filters to change table view, would it interrupt columns that are running?

Channeled
APP
·
·
This is happening because auto-update is enabled on your table. When auto-update is on, your table automatically runs all columns whenever rows are added or edited.To stop the company normalization column from re-running, you can turn off auto-update by: 1. Clicking the Auto-update icon at the bottom right of your table 2. Selecting "Turn Off Table"Alternatively, you can configure the company normalization column to run only under specific conditions by using formulas that trigger the column when certain criteria are met. Sources: Clay formatters overview | Documentation | Clay University Configuring your table settings | Documentation | Clay University Auto-update and Auto-dedupe Table
Andi Deng
·
·
will Clay table run on the cloud if I close the tabs?
Channeled
APP
·
·
Clay tables don't automatically run enrichments on a schedule when you close your tabs. The only exception is for tables with CRM sources, which update through a two-way sync every 24 hours. Source: Can I schedule data enrichments so they re-run on their own? - FAQ | Clay.com
Channeled
APP
·
·
I'm glad I could help! I'm here if you have any more questions.
Channeled
APP
·
·
Hi Andi Deng! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Andi Deng
·
·
if I refresh the table, would it interrupt all the columns that are running?
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Andi Deng
·
·
if I refresh the table, would it interrupt all the columns that are running?
Channeled
APP
·
·
Yes, refreshing the table can interrupt columns that are currently running. When columns are running in a waterfall setup, they process data sequentially, and refreshing the page would disrupt this process. If you need to preserve your data while making changes, it's recommended to wait until the current enrichments are complete before refreshing. Source: Enrich People (Waterfalls) [Clay 101] - Clay University
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.
Andi Deng
·
·
If I add in filters to change table view, would it interrupt columns that are running?