spread_cheats
making sheets work for you
About
Contact
Join Us
×
MENU
Data Cleaning
Developer
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.
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
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.
Data Generation
Get all combinations from sets in multiple lists in Google Sheets with COMBINE
Get all the combinations
Calculations
Sum a range by row in Google Sheets with SUMROWS
Sum any range by row
Data Generation
Transform dates to financial half year in Google Sheets with SEMIANNUAL
Convert a range of dates to financial half-year.
Data Generation
Transform dates to financial quarter in Google Sheets
Convert a dates to financial quarter in four different output formats.
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.
