Google sheets Our products Programming tricks Utility

Send Notification Email If a Cell is Changed in Google Spreadsheet

The live collaboration feature has turned the Google Spreadsheet into an awesome spreadsheet tool. We share our spreadsheets to multiple people with different level of access. Many times it happens that we want to be get notified when a cell in a specific range is updated. We need that updated value to be emailed to us. …

Continue Reading
Google Apps Script Programming tricks Tips

Custom Function to Get Place from Zip Code in Google Spreadsheet

Functions/formula are the most friendly way to quickly calculate something in a spreadsheet. There are a lot of in-built functions available in Google Spreadsheet, check here the list of all functions available. Google spreadsheet has also an option called custom function. When a calculation is repeatedly required at multiple places we can create a custom function for it. Just …

Continue Reading
Browser Google sheets Informative Programming tricks

Desktop Notification From Browser Using Google Spreadsheet

These days many sites have implemented browser notification. Its a new HTML5 feature which can show a quick alert on desktop. Of course users have to first allow the permission for the desktop notification to be displayed. You can see browser supports for notifications here .What a Browser Notification displays ?A notification is a small …

Continue Reading