Let’s say you have a Google Sheet with Multi Line text like: And you want to count how many times each phrase is mentioned or the most popular terms. keyword count Jquery 569 Google Tag Manager 438 Google Font Api … Continued
Although this is fairly easy to do, I ran into an issue and wanted to share some tips. Let’s say you want to return the matching text based on an existing list. In my case, I wanted to return the … Continued
If doing an IMPORTRANGE function in Google Sheets and you get the “You don’t have permissions to access that sheet.” error follow these steps: First make sure the sheet you are importing is NOT the XLSX version for Office Compatibility. … Continued
Took me a while to narrow it down but wanted to share the info in case you freaked out like I did at first. going directly to 682126721867.apps.googleusercontent.com did not reveal any information. Doing a WHOIS 34.197.187.40 returned Amazon as … Continued
Google Sheets QUERY Tips
This was driving me insane for the longest time. Its really easy to hide the grand totals in Excel but how to do it in Google Sheets? As I was trying to come up with creative solutions using custom formulas, … Continued
Google has upped their website CMS WYSIWYG (What you See is What You Get) editor in their rollout of the new Google Site Builder. If you have a classic Google Site and would like to update to the new Site … Continued