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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives