Intake sheet - new rows to contain formula
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
Answers
-
I made the field hidden and added the formula as default value. However, it prefixes it with an ' - how do I get around that?
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives