Smartsheet Mastery Exercises

Fill in the blanks to test your knowledge.

1

Smartsheet enforces ___ types on columns, so a Date column only accepts date values

const columnConfig = {
name: "Due Date",
type: "", // enforces only date values
enableGantt: true,
};
2

In a Smartsheet formula, ___ refers to the current row's value for a specific column

// Checks if Status in this row equals "Done"

=IF([Status] = "Done", 1, 0)

3

Curly braces {} in a Smartsheet formula reference a named ___ from another sheet

// Count tasks from another sheet that are "At Risk"

=COUNTIF(

{Project_Alpha_Status},

"At Risk"

)

// {} wraps a cross-sheet name

4

The ___ function aggregates values from child rows under a parent in a hierarchy

// Parent row formula — sum all child task hours

=SUM(())

// Reads the column value from every

// child row nested beneath this parent

5

An automation that sends editable form fields by email — letting recipients update data without logging in — is called an Update ___

const automationAction = {
type: "Update ",
trigger: "Row Updated",
condition: "Status changes to At Risk",
editableFields: ["Status", "% Complete", "Comments"],
};
6

A Smartsheet ___ aggregates live rows from multiple source sheets based on filter criteria

const crossSheetView = {
type: "",
sourceSheets: ["Project Alpha", "Project Beta"],
filter: { Status: "At Risk" },
updatesAutomatically: true,
};
7

Sheet ___ fields can hold aggregate formulas and feed data directly into dashboard metric widgets

const summaryField = {
section: "Sheet ",
fieldName: "Total At-Risk Tasks",
formula: "=COUNTIF([Status]:[Status], \"At Risk\")",
usedBy: "Dashboard Metric Widget",
};
8

COLLECT() returns an array of column values where a condition is met — commonly wrapped in ___ to display as a comma-separated string

// Get all blocked task names as a readable string

=(COLLECT(

[Task Name]:[Task Name],

[Status]:[Status],

"Blocked"

), ", ")

9

A single Smartsheet sheet supports a maximum of ___ inbound cell links

const platformLimits = {
rowsPerSheet: 20000,
inboundCellLinks: ,
crossSheetRefs: 100,
};
10

Smart ___ (2026) are AI-powered column types that automatically classify or summarize data in every row

const aiFeature = {
name: "Smart s",
examples: [
{ column: "Sentiment", aiTask: "classifies feedback as Positive/Neutral/Negative" },
{ column: "Category", aiTask: "auto-tags support tickets by topic" },
],
triggeredOn: "every new or updated row",
};