How to Populate Formulas Automatically in Excel Tables

·

Is there a way to force the formula to populate for the rest of the table?

· Sorted by Oldest

Channeled
APP
·
·
To force a formula to populate for the rest of the table, you can use the "force run" option. Here's how: 1. Click on the title of the column containing the formula. 2. In the dropdown menu, navigate to "Run column". 3. Select "Force run all x rows". This will re-run the formula for all rows in the table, which should populate the rest of the column. If you're specifically dealing with newly created columns from one table in another table's formula, you may need to re-run the company row in the people table to see the new values. If you continue to have issues, please request human assistance for more detailed guidance.
Source: Anjali D. | Clay
Stefano (Clay)
·
·
Hi Ken, thank you for reaching out. Formulas should automatically run for every row in the table. Is this not happening on your table?
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.

Channeled
APP
·
·
To force a formula to populate for the rest of the table, you can use the "force run" option. Here's how: 1. Click on the title of the column containing the formula. 2. In the dropdown menu, navigate to "Run column". 3. Select "Force run all x rows". This will re-run the formula for all rows in the table, which should populate the rest of the column. If you're specifically dealing with newly created columns from one table in another table's formula, you may need to re-run the company row in the people table to see the new values. If you continue to have issues, please request human assistance for more detailed guidance.
Source: Anjali D. | Clay
Stefano (Clay)
·
·
Hi Ken, thank you for reaching out. Formulas should automatically run for every row in the table. Is this not happening on your table?
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.