spread_cheats
making sheets work for you
About
Contact
Join Us
×
MENU
Developer
Data Cleaning
Marketing Operations
Revenue Operations
General
Utility cheats for every role.
These cheats are utilities that can be used across many roles and are less functionally specific.
Cheats for this Role
Data Generation
Convert a Google Sheets range to JSON with TABLE_TO_JSON
Convert a range to a JSON object with multiple items.
Cyrus Radfar
Jul 7, 2021
Data Generation
Convert a Google Sheets range into URL key & value parameters with TABLE_TO_KV
Prepare correctly encoded URL parameters from a range of data
Cyrus Radfar
Jul 7, 2021
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.
Cyrus Radfar
Jul 7, 2021
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.
Cyrus Radfar
Jul 7, 2021
Data Generation
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Convert a range of dates to financial half-year.
Cyrus Radfar
Jul 7, 2021
Data Generation
Transform dates to financial quarter in Google Sheets
Convert a dates to financial quarter in four different output formats.
Cyrus Radfar
Jul 7, 2021
Calculations
Sum a range by row in Google Sheets with SUMROWS
Sum any range by row
Lucas A. Browne Dias
Jul 7, 2021
Data Generation
Get all combinations from sets in multiple lists in Google Sheets with COMBINE
Get all the combinations
Lucas A. Browne Dias
Jul 7, 2021
