Topic

google sheets formulas

Essential Google Sheets formulas and functions. Tutorials, examples, and tips for beginners and advanced users.

XLOOKUP in Excel vs Google Sheets: Key Differences Explained

XLOOKUP works in both Excel and Google Sheets but with key differences. Compare syntax, wildcards, binary search, and cross-workbook behavior.

Feb 11, 20266 min read

Master SUMIF and SUMIFS in Google Sheets. Learn syntax, wildcard tricks, date ranges, multiple criteria, and fixes for common errors.

Feb 11, 20268 min read

Learn ARRAYFORMULA in Google Sheets to apply formulas to entire columns. Syntax, examples with IF and VLOOKUP, common errors, and tips.

Feb 10, 20267 min read

CONCATENATE or TEXTJOIN? Learn when to use each in Google Sheets with practical examples for combining names, emails, and CSV strings.

Feb 9, 20266 min read

Big CSV and Excel imports freeze the tab and lose work. SmoothSheet does them server-side, with a backup you can roll back to.

See how it worksGoogle sign-in, no card. Free plan covers 10 uploads a month.