spread_cheats
making sheets work for you
About
Contact
Join Us
×
MENU
Share your
#spreadcheats
Copy & paste verified solutions for Google Sheets
View Latest Cheats
Featured Cheats
Data Generation
Convert a Google Sheets range to JSON with TABLE_TO_JSON
Convert a range to a JSON object with multiple items.
TABLE_TO_JSON
Cyrus Radfar
Type Validation
Validate an inbound email list in Google Sheets with VALIDATE_EMAIL
Validate text is valid email format, top-level domain, and not from a spam domain.
VALIDATE_EMAIL
Cyrus Radfar
Most Recent
Data Generation
Convert a Google Sheets range into URL key & value parameters with TABLE_TO_KV
Convert a table of data into properly encoded key and value strings for passing parameters on a URL or elsewhere.
TABLE_TO_KV
Cyrus Radfar
Clean to Type
Add leading "0" other characters before a number or string in Google Sheets with PAD
Create fixed length strings from a number or text input with configurable leading characters.
PAD
Cyrus Radfar
Data Generation
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Convert a range of dates to financial half-year in four different output formats.
SEMIANNUAL
Cyrus Radfar
Calculations
Sum a range by row in Google Sheets with SUMROWS
Output the sum by row of several rows in a table without depending on filling down.
SUMROWS
Lucas A. Browne Dias
Data Generation
Get all combinations from sets in multiple lists in Google Sheets with COMBINE
Output all the different combinations of a sets of text in three formats.
COMBINE
Lucas A. Browne Dias