Author: admin
The REMOVE_ACCENTED function for Google Sheets will replace all accented characters in the referenced cell, like the letters è, õ, ā, ĝ and so on with their normal Latin equivalents. To get started, make a copy of the Google Sheet, go to the Tools menu, choose Script Editor and copy the entire code to your clipboard. Now open your own Google Sheet and paste the same code inside the Script editor of your sheet. Save and you should be able to use the REMOVE_ACCENTED function in your own sheets. Input StringOutput stringA História de Malú e João MiguelA Historia de…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
You have a workbook in Google Sheets that contains multiple rows of data and you are required to sort the list in a random order. For instance, your sheet may contain the names of your team members and you need to reshuffle the list before assigning tasks to each of the members randomly. Or your Google Sheet may have the email addresses of people who participated in a giveaway and you need to pick any three random entries in an unbiased manner for the prize. There are multiple ways to randomize the data rows in Google Sheet. You can either…
With its soaring temperatures, May ranks among the hottest months in the Indian subcontinent, prompting a desire to seek cooler destinations to alleviate the heat. Additionally, May marks the official summer vacation period in India, making it an ideal time for family getaways. Fortunately, India offers a plethora of locations to explore in May, ranging from the majestic Himalayas to picturesque hill stations and lush jungles. Whether you prefer backpacking or spending quality time with loved ones, these tourist places in India provide a refreshing escape from the summer heat with their mild climates, allowing you to relax and rejuvenate…
Notion, my absolute favorite tool for storing all sorts of things from web pages to code snippets to recipes, just got better. They’ve released a public API and thus it will be a lot easier for developers to read and write to their Notion workspace from external apps. For instance, you can create a document in Google Docs and export it to Notion while staying inside Docs. Google Sheets users can pull pages from Notion database into their spreadsheet. Any new submissions in Google Forms can be directly saved to Notion and so on! Save Gmail Messages in Notion I…
Would you like to receive notifications in your Telegram messenger when a new form response is submitted in Google Forms. Or maybe send a notification alert to your entire Telegram group when an important event happens. In this step-by-step tutorial, you’ll learn how to create a new Telegram bot and send messages to your Telegram channel and groups through this bot with the help of Google Apps Script. Create a new Telegram Bot Open the telegram app on your desktop or mobile phone and search for the @BotFather bot. This is the official Telegram bot that you can interact with…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
Dates are internally stored as sequential serial numbers in Google Sheets. This serial number represents the number of days elapsed since December 31, 1899. You can use the DATEVALUE function to convert any date input to a number that represents the date. For instance, both the functions DATEVALUE(“Jan 1”) and DATEVALUE(“01-Jan-2021”) return the same number (44197) though the inputs have vastly different formats. The function TODAY() returns the current date while the function NOW() returns the current date and time. Both these functions do not require any arguments and they update when any cell in the Google Sheet is changed.…
Razorpay is a popular payment gateway in India that allows you to accept online payments from customers anywhere in the world. Your customers can pay with credit cards, debit cards, Google Pay, Walmart’s PhonePe and other UPI apps. Razorpay, similar to Stripe, offers a simple no-code tool for generating payment links that you can share with customers over SMS, WhatsApp, or email. When a customer clicks on the link, they are redirected to a secure checkout page hosted on Razorpay where they can can make the payment using their preferred payment method. Here’s a sample payment link generated with Razorpay…
The Document Studio add-on helps you generate Google Documents from data in Google Sheets and Google Form responses. You can create a template in Google Docs and the add-on will replace the placeholders with answers submitted in the Google Form response. This approach may however create a lot of blank rows in the table for answers that have no response in Google Forms. To give you an example, if the user has not answered the Age question, the generated document will have a row for the {{Age}} question but with a blank value. Remove Blank Rows in Google Docs With…
The month of May in India is characterized by intense heat, yet it transforms into a vibrant and joyous period filled with remarkable festivals. These celebrations, which range from cultural to religious, captivate participants and provide a welcome distraction from the sweltering temperatures. They foster a sense of community and joy, showcasing the rich diversity of the nation through music, dance, and cultural expressions. Many of these events are held in the cooler hills, making them ideal for both sightseeing and trekking. To fully experience these festivities, consider planning your visit to align with one of these delightful celebrations as…
You run a coffee shop and you are looking for a spreadsheet formula to quickly look up prices of the product that your customer has ordered. You have the price matrix stored in a Google Sheet with the names of beverages in one column and the quantity-wise prices in the adjacent columns. When a customer selects their favorite beverage and the cup size, you can use the MATCH function to find the relative position of the column and row in the price table that matches the selected beverage and quantity. Next, use the INDEX function to find the actual price…