Whether you’re just starting out with Google Sheets or are a seasoned pro, sooner or later one of your formulas will give you a formula parse error message rather than the result you want. It can be frustrating, especially if it’s a longer formula where the formula parse error may not be obvious. In this … Continue reading When Your Formula Doesn’t Work: Formula Parse Errors in Google Sheets
💡 Add AI to your Google Sheets toolboxLearn how to use AI effectively with Google Sheets in my new online course: The AI Playbook for Google Sheets In this post, we’re going to take a 40,000 ft view of the Artificial Intelligence (AI) landscape and see how you can use it alongside Google Sheets to … Continue reading What AI Can Do For You As A Google Sheets User. Is The Hype Justified?
Recursion in Google Sheets is now possible with the introduction of Named functions, LAMBDA functions, and LET functions. In this post, we’ll explore the concept of recursion and look at how to implement recursion in Google Sheets.
The XLOOKUP function in Google Sheets is a new lookup function in Google Sheets that is more powerful and flexible than the older lookup functions like VLOOKUP or HLOOKUP.
Google announced Named Functions and 9 other new functions on 24th August 2022. The biggest news here is the new feature called Named Functions. Named Functions let you save and name your own custom formulas, built with regular Sheets functions, and then re-use them in other Google Sheet files. It’s a HUGE step toward making … Continue reading New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc.
