Smartsheet Core Product Certification
Exam | Verified Questions and 100%
Correct Answers | Grade A Study
Guide | Latest 2026/2027 Update
Question 1 What is the primary purpose of a Smartsheet Workspace?
A. To store individual sheets only B. To organize and share related sheets, reports, and
dashboards with specific users C. To create automated workflows across the entire organization
D. To serve as the main landing page for all Smartsheet users
Answer: B
Rationale: Workspaces in Smartsheet are used to group and organize related assets (sheets,
reports, dashboards) and control sharing/permissions at the workspace level.
Question 2 Which sharing permission level allows a user to view, edit, and manage the sheet
(including changing sharing settings)?
A. Viewer B. Commenter C. Editor D. Owner/Administrator
Answer: D
Rationale: Owner/Administrator has full control, including the ability to modify sharing
permissions, delete the sheet, and change structure. Editor can edit content but cannot change
sharing.
Question 3 In Smartsheet, what is the difference between a Report and a Dashboard?
A. Reports pull data from one sheet only; Dashboards pull from multiple sheets B. Reports are
live data views that can be filtered/sorted; Dashboards are visual summaries with widgets C.
Reports can include charts; Dashboards cannot D. Dashboards are editable; Reports are read-
only
Answer: B
,Rationale: Reports are dynamic filtered views of row data from one or more sheets. Dashboards
are visual pages built with widgets (charts, metrics, images, reports, etc.) for executive
summaries.
Question 4 Which column type in Smartsheet automatically calculates the number of days
between a start date and end date?
A. Date B. Duration C. Text/Number D. System – Modified Date
Answer: B
Rationale: The Duration column type automatically calculates working days between Start and
End date columns (supports dependencies when enabled).
Question 5 What is the purpose of the “Dependencies” feature in Smartsheet?
A. To create relationships between users B. To automatically calculate task durations and end
dates based on predecessors C. To share sheets with external collaborators D. To attach files to
rows
Answer: B
Rationale: Dependencies (Predecessors/Successors) enable Gantt chart functionality, auto-
adjusting dates when tasks are linked (FS, SS, FF, SF).
Question 6 Which feature allows you to see changes made to a sheet over time, including who
made them and when?
A. Activity Log B. Version History C. Cell History D. Sharing Log
Answer: C
Rationale: Right-click a cell → View Cell History shows all changes to that specific cell (value,
who, when). Sheet-level changes are in Activity Log.
Question 7 How can you make a column formula apply automatically to every row in a column?
, A. Right-click column → Convert to Column Formula B. Use @row in the formula C. Lock the
column D. Both A and B
Answer: D
Rationale: Column formulas use @row syntax (e.g., =[Due Date]@row - TODAY()) and are set
via “Convert to Column Formula” to apply consistently to all current and future rows.
Question 8 Which automation trigger would you use to notify a manager when a task status
changes to “Complete”?
A. When rows are added B. When rows are changed C. When a date is reached D. When an
approval request is completed
Answer: B
Rationale: “When rows are changed” trigger watches for changes to specified columns (e.g.,
Status column changed to “Complete”).
Question 9 What is the maximum number of items that can be displayed in a Dashboard Metric
widget?
A. 1 B. 5 C. 10 D. Unlimited
Answer: A
Rationale: Metric widgets display a single aggregated value (count, sum, average, etc.) from a
report or sheet.
Question 10 Which report setting allows a report to automatically include new rows added to the
source sheet(s)?
A. Run report on demand only B. Keep report results up to date C. Lock report filters D. Use
static criteria
Answer: B
Rationale: “Keep report results up to date” ensures dynamic reports reflect new/changed rows in
real time.
Exam | Verified Questions and 100%
Correct Answers | Grade A Study
Guide | Latest 2026/2027 Update
Question 1 What is the primary purpose of a Smartsheet Workspace?
A. To store individual sheets only B. To organize and share related sheets, reports, and
dashboards with specific users C. To create automated workflows across the entire organization
D. To serve as the main landing page for all Smartsheet users
Answer: B
Rationale: Workspaces in Smartsheet are used to group and organize related assets (sheets,
reports, dashboards) and control sharing/permissions at the workspace level.
Question 2 Which sharing permission level allows a user to view, edit, and manage the sheet
(including changing sharing settings)?
A. Viewer B. Commenter C. Editor D. Owner/Administrator
Answer: D
Rationale: Owner/Administrator has full control, including the ability to modify sharing
permissions, delete the sheet, and change structure. Editor can edit content but cannot change
sharing.
Question 3 In Smartsheet, what is the difference between a Report and a Dashboard?
A. Reports pull data from one sheet only; Dashboards pull from multiple sheets B. Reports are
live data views that can be filtered/sorted; Dashboards are visual summaries with widgets C.
Reports can include charts; Dashboards cannot D. Dashboards are editable; Reports are read-
only
Answer: B
,Rationale: Reports are dynamic filtered views of row data from one or more sheets. Dashboards
are visual pages built with widgets (charts, metrics, images, reports, etc.) for executive
summaries.
Question 4 Which column type in Smartsheet automatically calculates the number of days
between a start date and end date?
A. Date B. Duration C. Text/Number D. System – Modified Date
Answer: B
Rationale: The Duration column type automatically calculates working days between Start and
End date columns (supports dependencies when enabled).
Question 5 What is the purpose of the “Dependencies” feature in Smartsheet?
A. To create relationships between users B. To automatically calculate task durations and end
dates based on predecessors C. To share sheets with external collaborators D. To attach files to
rows
Answer: B
Rationale: Dependencies (Predecessors/Successors) enable Gantt chart functionality, auto-
adjusting dates when tasks are linked (FS, SS, FF, SF).
Question 6 Which feature allows you to see changes made to a sheet over time, including who
made them and when?
A. Activity Log B. Version History C. Cell History D. Sharing Log
Answer: C
Rationale: Right-click a cell → View Cell History shows all changes to that specific cell (value,
who, when). Sheet-level changes are in Activity Log.
Question 7 How can you make a column formula apply automatically to every row in a column?
, A. Right-click column → Convert to Column Formula B. Use @row in the formula C. Lock the
column D. Both A and B
Answer: D
Rationale: Column formulas use @row syntax (e.g., =[Due Date]@row - TODAY()) and are set
via “Convert to Column Formula” to apply consistently to all current and future rows.
Question 8 Which automation trigger would you use to notify a manager when a task status
changes to “Complete”?
A. When rows are added B. When rows are changed C. When a date is reached D. When an
approval request is completed
Answer: B
Rationale: “When rows are changed” trigger watches for changes to specified columns (e.g.,
Status column changed to “Complete”).
Question 9 What is the maximum number of items that can be displayed in a Dashboard Metric
widget?
A. 1 B. 5 C. 10 D. Unlimited
Answer: A
Rationale: Metric widgets display a single aggregated value (count, sum, average, etc.) from a
report or sheet.
Question 10 Which report setting allows a report to automatically include new rows added to the
source sheet(s)?
A. Run report on demand only B. Keep report results up to date C. Lock report filters D. Use
static criteria
Answer: B
Rationale: “Keep report results up to date” ensures dynamic reports reflect new/changed rows in
real time.
