How to Populate Formulas Automatically in Excel Tables

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

Hi Ken, thank you for reaching out. Formulas should automatically run for every row in the table. Is this not happening on your table?