> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superjoin.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Formula Auto Filldown

<Check> Only available on Google Sheets </Check>

### Introduction

Formula filldown automatically populates any formulas that you have in the spreadsheet in the immediate right columns of the imported data every time you refresh the data.
This saves you the time (and hassle) of manually going into your spreadsheet and copying your formula(s) down the row(s) manually.

<img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/sheets/formulae-filldown.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=c9bae1190263870cc6f14f1992d35a08" width="1480" height="692" data-path="images/sheets/formulae-filldown.png" />

## How to use Formula filldown

<Steps titleSize="h3">
  <Step title="Import Data with Superjoin">
    Use Superjoin to import data from your preferred source. Navigate to the `Sources` tab in the Superjoin sidebar, and connect to your
    desired data source (e.g., HubSpot, Salesforce, etc). Click on import data (in data preview) and wait for your data to be populated on
    Google sheet.

    <Frame>
      <img src="https://mintcdn.com/superjoin/tR1QsuikxI8kxuAE/images/chargebee/previewdata-step8.png?fit=max&auto=format&n=tR1QsuikxI8kxuAE&q=85&s=91ad5a0c8e2c78d96074176e5b2b5f73" width="2430" height="1414" data-path="images/chargebee/previewdata-step8.png" />
    </Frame>
  </Step>

  <Step title="Add your custom columns with formulas">
    Open the sheet where you'd like to import data. Ensure that any formulas you want to apply to imported data are in the columns immediately
    next to the imported data.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/sheets/custom-columns.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=038be42aff87239573e35a0ea09303bd" width="1062" height="702" data-path="images/sheets/custom-columns.png" />
    </Frame>
  </Step>

  <Step title="Refresh your data">
    When you refresh the data, the formula you placed in the immediate next column will automatically populate down the rows of your imported
    data during every refresh. No need to manually copy formulas anymore!

    <Info>
      **Note:** Ensure the column with the formula is directly adjacent to the imported data, as the filldown only works for immediate
      columns.
    </Info>

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/sheets/formulae-filldown.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=c9bae1190263870cc6f14f1992d35a08" width="1480" height="692" data-path="images/sheets/formulae-filldown.png" />
    </Frame>
  </Step>

  <Step title="Schedule Data Refresh">
    To automatically refresh your data and keep your formulas updated, you can schedule a refresh in Superjoin. Navigate to the `Schedule`
    option and set a daily, weekly, or monthly refresh. Make sure to keep the Formula Auto-filldown mode on.

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/sheets/filldown-toggle.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=7188c8ad6a0fa89b67e046c6d61749b6" width="764" height="668" data-path="images/sheets/filldown-toggle.png" />
    </Frame>

    ##

    <Frame>
      <img src="https://mintcdn.com/superjoin/3kfktSzO4qKVejPu/images/sheets/append-mode.png?fit=max&auto=format&n=3kfktSzO4qKVejPu&q=85&s=19f0704f30431752b94c81d4a884dfcb" width="712" height="1130" data-path="images/sheets/append-mode.png" />
    </Frame>
  </Step>

  <Step title="Verify Formula Population">
    After the refresh, verify that your formulas have populated correctly in the new rows of the data, ensuring your spreadsheet stays up to
    date.
  </Step>
</Steps>

***

## Frequently Asked Questions

**Q. Can I write formula on a column which is not the immediate column?**

No, if there is a gap between the imported data and the column with the formula, the formula will not be applied. Formulae filldown only works for columns immediately adjacent to the imported data.

**Q. Will it work if the formula is not on the first row of the data?**

Yes, the formula will still be applied even if it’s not in the first row. As long as the formula is in the column immediately next to the imported data, it will fill down through all the rows below it.

**Q. What happens when I have multiple columns that have formula?**

Superjoin will fill down all formulas in the immediate adjacent columns. If there are multiple formulas in the columns directly next to the data, they will all be applied during the refresh, maintaining the order of your data structure.

**Q. What is the behaviour when I setup a refresh schedule?**

You have the functionality to choose whether you wish to activate Formula filldown with the refresh schedule when you step up a schedule. With Formula filldown, all adjacent formulas will populate automatically with each data refresh, ensuring that your formulas always stay up-to-date.