Intake sheet - new rows to contain formula

nlenehan

Hi,

In my intake sheet a form creates new rows. How do I have a new line automatically contain a formula? (In this case it's a cross-sheet vlookup.)

Thanks, Nichola

nlenehan

I made the field hidden and added the formula as default value. However, it prefixes it with an ' - how do I get around that?

Genevieve P.

Hi @nlenehan

You don't need to include the column with the formula into the form - as new rows populate, the formula will auto-populate down in the sheet itself. To do so, it just needs to be present in two rows above or below where the new rows are coming in.

This Help Center article (here) has more information on auto-fill & formulas!

Let me know if you have questions about this.

Cheers,

Genevieve