Google Sheets – How to extract the matching text based on a list
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
How to fix the “You don’t have permissions” error in Google Sheets IMPORTRANGE
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
How to fix “Processing webhook: Webhook user no longer in account. ” in Aha! Roadmap tool
If you use Aha! Roadmap tool, you have JIRA integrated and received the following error: “Processing webhook: Webhook user no longer in account. ” this usually means that the user assigned to the Aha WebHook no longer exists in Aha user … Continued
How To Recover Your Sessions In Notepad++ During Crashes
Are you having that annoying and common issue where Notepad++ crashes or won’t start up? There are lots of articles about how to get Notepad++ to start up with the -noSessions and -noPlugins command line argument already. But how can … Continued
What is Gmail Authorized Application “682126721867 .apps.googleusercontent.com”??
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
Why is Accessibility, ADA and Section 508 Compliance so important and how do I fix it?
A few years ago, a company I work for, started getting slammed with requests to ensure that our online content platform and content itself was Section 508 compliant or WCAG accessible for eCommerce sites. What is it? What does that … Continued
Installing pimcore via ampps returns PHP Version error
If you use ampps for a local dev stack or for production, you may run into errors while trying to install pimcore: “Required PHP version less than 7.2.0 AND found version is : 7.3.11“ Apparently softaculous isn’t quite smart enough … Continued
Google Sheets QUERY Tips
Google Sheets QUERY Tips
How to hide Grand Total row in Google Sheets Pivot Charts
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
TUNE IN MONDAY TO THE WORLD OF X GAMES
EPISODE 2 FEATURES THE 2020TOYO TIRES DESERT Invitational Presented by MONSTER ENERGYDATE: April 20 / 21stTIME: 1 AM EDT / 10 PM PDTCheck your local listings.