Quip Spreadsheet Formulas - Quick Reference Guide

This quick reference guide answers a common question for Quip users: which spreadsheet functions and formulas are available, and how are they used in real formulas? It groups common Quip Spreadsheet functions by category, each with a short description and example, and closes with a practical project-tracking scenario and alt-text examples for documenting spreadsheet screenshots.

Math & Statistics

SUM - Adds all numbers in a range. Example: =SUM(A1:A10)

AVERAGE - Returns the average of numbers. Example: =AVERAGE(B1:B10)

COUNT - Counts how many cells contain numbers. Example: =COUNT(C1:C10)

COUNTA - Counts non-empty cells. Example: =COUNTA(D1:D10)

MAX - Returns the largest value. Example: =MAX(E1:E10)

MIN - Returns the smallest value. Example: =MIN(F1:F10)

ROUND - Rounds a number to specified decimals. Example: =ROUND(A1, 2)

ABS - Returns absolute value. Example: =ABS(-25) returns 25

MULTIPLY - Multiplies two numbers. Example: =MULTIPLY(A1, B1)

DIVIDE - Divides two numbers. Example: =DIVIDE(A1, B1)

Text Functions

CONCATENATE - Combines text strings. Example: =CONCATENATE(A1, " ", B1)

CONCAT - Combines strings (newer version). Example: =CONCAT(A1:C1)

LEFT - Returns leftmost characters. Example: =LEFT(A1, 5)

RIGHT - Returns rightmost characters. Example: =RIGHT(A1, 3)

MID - Extracts characters from middle. Example: =MID(A1, 2, 5)

LEN - Returns length of text. Example: =LEN(A1)

UPPER - Converts text to uppercase. Example: =UPPER(A1)

LOWER - Converts text to lowercase. Example: =LOWER(A1)

TRIM - Removes extra spaces. Example: =TRIM(A1)

SUBSTITUTE - Replaces text in a string. Example: =SUBSTITUTE(A1, "old", "new")

Lookup & Reference

VLOOKUP - Vertical lookup in a table. Example: =VLOOKUP(A1, B:D, 2, FALSE)

HLOOKUP - Horizontal lookup in a table. Example: =HLOOKUP(A1, B1:D10, 2, FALSE)

INDEX - Returns value at row/column intersection. Example: =INDEX(A1:C10, 2, 3)

MATCH - Returns position of value in range. Example: =MATCH("Apple", A1:A10, 0)

CHOOSE - Returns value from list by index. Example: =CHOOSE(2, "Red", "Blue", "Green")

Logical Functions

IF - Performs logical test. Example: =IF(A1>10, "Yes", "No")

AND - Returns TRUE if all conditions are TRUE. Example: =AND(A1>5, B1<10)

OR - Returns TRUE if any condition is TRUE. Example: =OR(A1>5, B1<10)

NOT - Inverts logical value. Example: =NOT(A1=B1)

IFERROR - Returns alternative if error. Example: =IFERROR(A1/B1, "Error")

IFNA - Returns alternative if #N/A. Example: =IFNA(VLOOKUP(A1,B:D,2,FALSE), "Not Found")

Date & Time

TODAY - Returns current date. Example: =TODAY()

NOW - Returns current date and time. Example: =NOW()

DATE - Creates date from year/month/day. Example: =DATE(2026, 6, 2)

YEAR - Extracts year from date. Example: =YEAR(A1)

MONTH - Extracts month from date. Example: =MONTH(A1)

DAY - Extracts day from date. Example: =DAY(A1)

WEEKDAY - Returns day of week (1-7). Example: =WEEKDAY(A1)

NETWORKDAYS - Counts workdays between dates. Example: =NETWORKDAYS(A1, B1)

EDATE - Date x months before/after. Example: =EDATE(A1, 3)

DATEDIF - Calculates difference between dates. Example: =DATEDIF(A1, B1, "D")

Conditional Counting & Summing

COUNTIF - Counts cells meeting criteria. Example: =COUNTIF(A1:A10, ">5")

COUNTIFS - Counts cells meeting multiple criteria. Example: =COUNTIFS(A:A, "Complete", B:B, ">100")

SUMIF - Sums cells meeting criteria. Example: =SUMIF(A1:A10, ">5", B1:B10)

SUMIFS - Sums cells meeting multiple criteria. Example: =SUMIFS(C:C, A:A, "Complete", B:B, ">100")

AVERAGEIF - Averages cells meeting criteria. Example: =AVERAGEIF(A1:A10, ">5")

AVERAGEIFS - Averages cells meeting multiple criteria. Example: =AVERAGEIFS(C:C, A:A, "Complete", B:B, ">100")

Data Analysis

FILTER - Filters data based on criteria. Example: =FILTER(A1:C10, B1:B10>50)

SORT - Sorts data from range. Example: =SORT(A1:C10, 2, TRUE)

UNIQUE - Returns unique values. Example: =UNIQUE(A1:A100)

COUNTUNIQUE - Counts unique values. Example: =COUNTUNIQUE(A1:A100)

Real-World Scenario: Project Management Task Tracking

Sarah is a project manager tracking team tasks in a Quip spreadsheet. She needs to monitor completion status, calculate completion rates, and identify overdue items.

Sample data structure: Column A - Task Name; Column B - Status (Complete, In Progress, Not Started); Column C - Due Date; Column D - Priority (High, Medium, Low); Column E - Assigned To.

Sarah builds a project dashboard using these formulas:

Visual status indicator: =IF(COUNTIFS(B:B, "<>Complete", C:C, "<"&TODAY()) > 5, "Action Needed", "On Track"). This shows an alert if more than 5 tasks are overdue.

Image Descriptions (Alt Text Examples)

When adding images to your Quip spreadsheet documentation, use descriptive alt text so the content is accessible and so Agentforce can reference what the image shows:

Formula bar screenshot - Alt text: "Screenshot showing the Quip formula bar with the VLOOKUP formula =VLOOKUP(A2,Sheets!A:D,3,FALSE) entered, highlighting the cell reference and formula syntax."

COUNTIF example - Alt text: "Spreadsheet example showing COUNTIF formula counting tasks marked as 'Complete' in column B, with result showing 15 out of 25 total tasks completed."

Dashboard visual - Alt text: "Project management dashboard showing key metrics: 70% completion rate, 3 overdue tasks displayed in red, and a pie chart breaking down tasks by status (Complete: 35, In Progress: 10, Not Started: 5)."

VLOOKUP diagram - Alt text: "Diagram illustrating VLOOKUP function with color-coded arrows showing: lookup value in blue, table range in green, column index in orange, and return value highlighted in yellow."

Date function example - Alt text: "Calendar visualization showing NETWORKDAYS function calculating 15 workdays between May 1 and May 22, excluding weekends highlighted in gray and two holiday dates marked with stars."