Data Cleaning

General

Marketing Operations

Revenue Operations

Developer

Developer

A developer is an individual that builds and create software and applications. They write, test and, often deploy the the code for an application. A developer is also known as a software developer, computer programmer, programmer, software coder or software engineer.

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

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

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.

Be the first to know when new Cheats are posted

Thank you for joining our list. If you'd like to join our community submit this survey.

Oops! Something went wrong while submitting the form. Email us at support@spine.dev