How to Copy a Formula Down an Entire Column in Google Sheets

-

Comments

Post a Comment

Popular posts from this blog

The 101 Most Useful Websites

-
Image
Presenting the 101 most useful websites on the internet. These sites, well most of them, solve at least one problem really well and they all have simple web addresses (URLs) that you can memorize thus saving you a trip to Google. The Most Useful Websites and Web Apps ctrlq.org/screenshots  – for capturing  screenshots of web pages  on mobile and desktops. dictation.io  – online voice recognition in the browser itself. zerodollarmovies.com  – find full-length movies on YouTube. screenr.com  – record movies of your desktop and send them straight to YouTube. goo.gl  – shorten long URLs and convert URLs into  QR codes . unfurlr.come  – find the original URL that’s hiding behind a short URL. qClock  – find the local time of a city using a  Google Map . copypastecharacter.com  – copy special characters that aren’t on your keyboard. postpost.com  – a better search engine for twitter. lovelycharts.com  – c...
Read more

How to Send a Welcome Email to Google Form Respondents

-
Image
“Tech and AI” - that’s the theme of an upcoming event we are organizing in New York. We have created a Google Form to collect registrations and would like to send a welcome email automatically to each person as they fill the form. The email should be personalized and include the name of the attendee. We would like also attach a PDF file, with the speaker bios and other details about the event, to the email. Google Form for Event Registration Here’s a sample Google Form that we are using to collect registrations for the event. The form requires attendees to fill in their name, email address and their preferred date to attend the event. Personalized Welcome Email Since we would like to send a personalized email to each attendee, we’ll use markers in the email template that will be replaced with the actual values from the Google Form. For instance, if we use the marker in the email template, it will be replaced with the actual name of the attendee that is filled in the Google F...
Read more