Spreadsheet Function Reference

Add up a column of revenue values—including blanks safely ignored by SUM.

Return the mean of a range while skipping empty cells automatically.

Round a value to two decimal places for currency reporting.

Force numbers to round up to the next 0.25 increment—helpful for utilization.

Drop any cents or decimals to keep spend figures conservative.

Count how many entries exist in a column, ignoring blanks.

Restrict counting to numeric cells only, excluding text labels.

Return the minimum value in a range—useful for spotting dips.

Return the maximum value in a range to locate peaks.

Convert negative numbers to positive values before aggregations.

Take the square root of a variance metric for volatility analysis.

Use POWER to calculate exponential adjustments, like compounding.

Remove surrounding whitespace and standardize casing for identifiers like region codes.

Lowercase an email, strip extra spaces, and ensure the field isn't blank before saving.

Check that a string is a valid date. Returns "Invalid" for malformed inputs so your workflow can branch.

Remove any characters except digits before casting a value to numeric types.

Standardize names or job titles by trimming spaces and applying proper case.

Flags repeated values so you can deduplicate lists before automating downstream steps.

Ensure string content doesn't exceed a character cap before export.

Classify metrics as "Healthy" or "Needs review" based on a simple threshold.

Return different labels depending on which range a metric falls into.

Ensure both MRR and NPS thresholds pass before flagging an account as healthy.

Trigger an escalation if either churn exceeds 5% or incidents are above five.

Wrap a condition in NOT to invert boolean results.

Use IFS to simplify multiple IF conditions for lead qualification scoring.

Map plan codes to human-readable labels without a lookup table.

Fetch a customer's tier from another sheet, returning "Not found" if the ID is missing.

Use INDEX/MATCH to pull the SKU description when the inventory table isn't sorted.

Sum values for rows that match a specific region label.

Aggregate pipeline value for a specific account and stage combination.

Return only the rows from Status sheet where incidents are still open.

Classic VLOOKUP example when you only need the third column from the region table.

Use HLOOKUP when plan identifiers span the first row instead of the first column.

Compute a 7-day moving average for the metric in column C, ignoring blanks.

Raise a flag when churn exceeds 5% so you can notify stakeholders downstream.

Running total that accumulates revenue while skipping blank rows.

Multiply deal amounts by probability percentages to get a weighted forecast.

Show each row's contribution to the overall total, ideal for dashboards.

Count how many rows meet a single criterion, such as risk = high.

Count opportunities that match multiple filters simultaneously.

Calculate the 90th percentile response time to track near-worst-case performance.

Sum the last seven days of metric values anchored to the current row's date.

Average a metric only when the related status meets your condition.

Use SUBTOTAL to respect filters and hidden rows for pivot-like summaries.

Align any date to the Monday of that week for grouping in reports.

Return today's date so dashboards can show "as of" context.

NOW updates whenever the sheet recalculates—useful for monitoring data freshness.

Return the final day of the month to anchor monthly close metrics.

Count working days between two dates while excluding holidays.

Shift a timestamp by a number of hours—helpful for SLA deadlines.

Format a datetime for APIs that expect ISO 8601 strings.

Jump ahead three working days, skipping weekends and holidays.

Build a valid date from year, month, and day columns.

Assemble hours, minutes, and seconds into a single time value.

DATEDIF calculates elapsed days even when the start is before the end.

Combine UNIQUE and SORT to create quick picklists for data validation.

Turn a column into a comma-separated string for logs or API payloads.

Produce sequential IDs or counters without manual typing.

Break a delimited list into separate columns for additional analysis.

Apply lowercase to an entire column in one formula for consistent comparisons.

Use LEFT to keep the first n characters of a string (after trimming).

Use RIGHT to grab trailing codes, such as the last four digits.

Use MID when you need a portion of a string from the middle.

LEN tells you how many characters appear in a cell after trimming.

Combine multiple text fields into a single label with separators.

Create a text representation of a number with a currency symbol.

Create a small JSON payload to post into another system without leaving your sheet.

Combine date and customer ID to produce a unique key for deduplication.

Create a multi-line Slack message with Markdown formatting from sheet values.

Compact record values into a URL-encoded parameter string for HTTP actions.

Wrap values in quotes and join them for an IN() clause inside workflow SQL nodes.

Ensure both inputs are present before passing control to downstream blocks.

Replace calculation failures with a readable error string for dashboards.

Flag values that deviate more than two standard deviations from the mean.

Log the execution time of a workflow step in a human-readable format.