Copy Down Google Sheet Formulas in Google Form Responses
HTML-код
- Опубликовано: 22 авг 2024
- If you use Google Sheets to work with responses from a Google Form and are looking for a way to copy down formulas on each response, this video is for you. You can convert the responses sheet to a table and add your columns of formulas. When each new response gets submitted, the formulas get applied.
FYI - The Chrome extension I use for filling in sample data is Fake Filler. You can learn more about it here - fakefiller.com
With all of my heart and soul I want to say thank you very much for this tutorial. Since the CopyDown is down I have to copy and paste formula manually whenever data submitted by Google form. I've been try for lot of CopyDown alternative and none of them works like what I need. But this, this is more simple yet effective. Thank you thank you thank you ❤❤❤
Love this update! Thanks for the great tutorial!
Merci pour ce tuto très utile. J'étais également en recherche d'une nouvelle solution puisque COPY DOWN ne fonctionne plus. C'est parfait. Merci beaucoup. Gil
Does the table still work seamlessly with Awesome Tables? Noting row 1 is the headers, & row 2 must be the tags to identify the datatype to be displayed.
Can this work with Awesome Tables? Row 1 Headers, Row 2 Awesome Table data type tags