What is Formula Auto Fill Down?

How do I use Formula Auto Fill Down?

FAQs for Formula Auto Fill Down

What is Formula Auto Fill Down?

Coefficient’s Formula Auto Fill Down will copy any formula(s) you have immediately to the right of your imported data columns as your data refreshes and new rows are added or removed. This saves you the time (and hassle) of manually going into your sheet and copying your formula(s) down the row(s) manually. What a time saver! ⏰ 💡

How do I use Formula Auto Fill Down?

We will use the following Salesforce (Opportunities) import as an example of this feature. In Column H we are calculating the percentage of each Opportunity Amount vs. the Total of all.

1. From the sidebar, click on your import (Salesforce Opportunities).

1. Scroll down to the Advanced Settings > Check the Auto fill down formulas box.

1. Add/Update your formula(s) in the columns with your import. Click Run to update.

1. Your import will now refresh pulling in the additional row(s) and copying the formula down to those (newly added) rows. 🎉 👍

FAQs for Formula Auto Fill Down

Are all formulas supported with this feature?

Formula Auto Fill Down works for MOST formulas that a user may need in a spreadsheet, however Array-type formulas are not supported. (Arrays, Unique, and Query are not supported) This is expected as these types of formulas only exist in row 2 next to your imported data and will not be auto-filled down the sheet/applied to each row.

How can I use the formula auto fill down feature with Coefficient?