All Practice Exams

100+ Free Smartsheet Core Product Certification Practice Questions

Pass your Smartsheet Core Product Certification exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which formula correctly sums all of the child rows directly beneath a parent row?

A
B
C
D
to track
2026 Statistics

Key Facts: Smartsheet Core Product Certification Exam

$149

Exam fee per attempt (USD)

Smartsheet University

80%

Passing score on each part

Smartsheet

2 parts

50 MCQ + sheet manipulation exercise

Smartsheet Product Certification Prep Guide

2 years

Certification validity

Smartsheet

Open book

Help Center and Community allowed

Smartsheet Certification FAQ

3-6 months

Recommended platform experience before testing

Smartsheet

The Smartsheet Core Product Certification is a two-part, open-book exam from Smartsheet University costing $149 per attempt. Part 1 is a 50-question multiple-choice test and Part 2 is a sheet manipulation exercise; you must score 80% on each part to pass, and Part 1 must be passed before Part 2. The certification is valid for two years. It covers sheets, rows, columns and column types; formulas and cross-sheet references; reports, dashboards (Sights), and Card view; automated workflows, alerts, and actions; forms; and sharing, permissions, and collaboration.

Sample Smartsheet Core Product Certification Practice Questions

Try these sample questions to test your Smartsheet Core Product Certification exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1In a Smartsheet grid, which column is automatically created and serves as the default label for cards in Card view and the title of rows in reports?
A.The Auto-Number column
B.The first Contact List column
C.The System Created Date column
D.The Primary column
Explanation: Every Smartsheet sheet has exactly one Primary column. It cannot be deleted or moved to a different position type, and its value is used as the card title in Card view and as the row identifier in reports. The Primary column is always a Text/Number column.
2A team needs a column where users can only pick from a fixed set of values such as Not Started, In Progress, and Complete. Which column type is the correct choice?
A.Text/Number
B.Contact List
C.Dropdown List
D.Auto-Number
Explanation: A Dropdown List column restricts entries to a predefined list of options, which keeps status values consistent and makes filtering, grouping, and automation reliable. You can allow single-select or multi-select values when configuring the column.
3Which statement about the Contact List column type in Smartsheet is correct?
A.It can store only a person's display name, never an email address
B.It supports an unlimited number of contacts per cell by default
C.Only email addresses in a Contact List can work with automation and contact-specific features
D.It is the only column type that can be set as the Primary column
Explanation: In a Contact List column the acceptable values are contact name, email address, and name, but only the email address can drive automation, @mentions, and other contact-specific features. Other text is treated as free text and will not work with notifications.
4How many Auto-Number columns can a single Smartsheet sheet contain?
A.Unlimited
B.Three
C.One per workspace
D.One
Explanation: A sheet can have only one Auto-Number column. The Auto-Number system column generates an incremented value for every data row and is commonly used for row IDs, part numbers, or invoice numbers without manual typing.
5A symbol column in Smartsheet (such as one displaying a flag or star) is technically built on which underlying column types?
A.Text/Number or Date
B.Contact List or Date
C.Checkbox or Picklist
D.Auto-Number or System
Explanation: Symbol columns are specialized Checkbox or Picklist columns whose symbol attribute is set to a value such as FLAG or STAR for checkboxes, or a colored set like Red-Yellow-Green for picklists. You choose from built-in symbol sets and cannot upload custom symbols.
6Which of the following is a Smartsheet system column whose value is filled in automatically and cannot be edited by a user?
A.Dropdown List
B.Duration
C.Modified Date
D.Symbols
Explanation: Modified Date is a system column that records when a row was last changed. System columns such as Created By, Created Date, Modified By, and Modified Date are maintained by Smartsheet and their values cannot be manually changed.
7A user indents several rows beneath a summary row in grid view. What relationship has this created?
A.A locked row group
B.A parent row with child rows (hierarchy)
C.A cross-sheet reference
D.A linked dropdown
Explanation: Indenting rows under another row creates hierarchy, making the top row a parent and the indented rows its children. Hierarchy enables roll-up calculations with functions like SUM(CHILDREN()) and collapsible groups in the grid.
8Which sheet view in Smartsheet displays rows as draggable cards arranged in lanes, ideal for a Kanban-style workflow?
A.Card view
B.Grid view
C.Gantt view
D.Calendar view
Explanation: Card view (also called board view) shows each row as a card grouped into lanes based on a Dropdown, Contact List, or Symbol column. Dragging a card between lanes updates the underlying column value, supporting Kanban-style status tracking.
9To use Gantt view with dependencies in Smartsheet, which two date columns must the sheet contain?
A.Created Date and Modified Date
B.Start Date and End Date (Date type)
C.Two Auto-Number columns
D.A single Duration column only
Explanation: Gantt view and project dependencies require two Date-type columns, typically named Start Date and End Date (Finish). When dependencies are enabled, Smartsheet can calculate End Date or Duration automatically based on the working calendar.
10What is the maximum number of contacts that can be selected in a single cell of a Contact List column configured to allow multiple contacts?
A.20
B.5
C.10
D.Unlimited
Explanation: When you enable the multiple-contacts option on a Contact List column, each cell can hold up to 20 contacts. This is useful for assigning a task to a small team while still allowing each contact's email to drive automation.

About the Smartsheet Core Product Certification Exam

The Smartsheet Core Product Certification validates that a user can confidently use Smartsheet to build and manage work solutions. It is a two-part exam administered through Smartsheet University: Part 1 is a 50-question multiple-choice test, and Part 2 is a hands-on feature manipulation exercise that must be passed after Part 1. The blueprint covers building sheets and choosing column types (Text/Number, Date, Dropdown, Contact List, Checkbox, Symbols, Auto-Number, and System), writing formulas and cross-sheet references, creating reports and dashboards (Sights), configuring Card view, building automated workflows with triggers, conditions, and actions, designing forms, and managing sharing and permissions. The exam is open book and virtually proctored, and the certification is valid for two years.

Questions

50 scored questions

Time Limit

Approximately 2 to 4 hours total (open book)

Passing Score

80% on each part

Exam Fee

$149 per attempt (Smartsheet University (SmartU))

Smartsheet Core Product Certification Exam Content Outline

20-25%

Sheets, rows, columns, and column types

Create and organize sheets; build parent-child hierarchy by indenting rows; pick the correct column type among Text/Number, Date, Dropdown, Contact List, Checkbox, Symbols, Auto-Number, and System; and work across grid, Gantt, Card, and Calendar views, including locking and conditional formatting.

15-20%

Formulas and cross-sheet references

Write formulas with SUM, COUNTIF, INDEX/MATCH, COLLECT, and JOIN; use @row and column formulas; apply hierarchy functions CHILDREN, PARENT, and ANCESTORS; build cross-sheet references with curly-brace named ranges; and recognize errors such as #CIRCULAR REFERENCE and #UNSUPPORTED CROSS-SHEET FORMULA.

18-22%

Reports, dashboards (Sights), and Card view

Build bi-directional row reports and sheet summary reports from source sheets; assemble dashboards (Sights) from chart, metric, report, shortcut, rich text, image, and web content widgets; and configure Card view lanes and fields using Dropdown, Contact List, or Symbol columns.

18-22%

Automated workflows, alerts, and actions

Combine triggers, optional conditions, and actions; set up alerts, reminders, approval requests, and update requests; use Move row, Change cell value, Lock row, and Assign people actions; and apply workflow permission rules where Editors can only manage notifications for themselves.

8-12%

Forms

Create forms whose fields map to sheet columns; apply conditional logic to show or hide fields, mark fields required, and choose display options; configure submission behavior such as new-row placement; and embed forms in dashboards with the web content widget.

12-16%

Sharing, permissions, and collaboration

Apply the five sharing levels (Viewer, Commenter, Editor, Admin, Owner); distinguish a license from a sharing permission; share at the workspace level; understand internal versus external users and guests; and know the account-level System Admin role.

How to Pass the Smartsheet Core Product Certification Exam

What You Need to Know

  • Passing score: 80% on each part
  • Exam length: 50 questions
  • Time limit: Approximately 2 to 4 hours total (open book)
  • Exam fee: $149 per attempt

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Smartsheet Core Product Certification Study Tips from Top Performers

1Memorize the column types and when to use each: Dropdown for fixed lists, Contact List for people (only emails drive automation), Checkbox/Symbols for status, Auto-Number for IDs (one per sheet), and the read-only System columns.
2Get fluent with formulas: @row for same-row references, column formulas that apply to every row, hierarchy functions CHILDREN/PARENT/ANCESTORS (not allowed cross-sheet), and INDEX/MATCH over VLOOKUP for performance.
3Know the three workflow building blocks cold: trigger (WHEN), optional condition (IF), and action (THEN), plus the difference between Alert, Reminder, Approval request, and Update request.
4Distinguish report types and widgets: row reports aggregate rows, sheet summary reports aggregate summary fields, and dashboards (Sights) are built from chart, metric, report, shortcut, rich text, and web content widgets.
5Drill the five sharing levels and what each can do; remember Editors can only manage alerts/reminders for themselves, only Admins/Owners create forms and workflows, and a license differs from a sharing permission.
6Build a sample solution end to end before testing: a sheet with a form, cross-sheet formulas, a dashboard, and an approval workflow, since Part 2 is a hands-on feature manipulation exercise.

Frequently Asked Questions

What are the exam facts for the Smartsheet Core Product Certification?

It is a two-part, open-book exam from Smartsheet University costing $149 per attempt. Part 1 is a 50-question multiple-choice test and Part 2 is a sheet manipulation exercise; you need 80% on each part, and the certification is valid for two years.

What topics does the Core Product Certification cover?

It covers building sheets and choosing column types, writing formulas and cross-sheet references, creating reports and dashboards (Sights), configuring Card view, building automated workflows, designing forms, and managing sharing and permissions across the Smartsheet platform.

Do I have to pass Part 1 before taking Part 2?

Yes. Part 1, the 50-question multiple-choice test, must be passed before you can enter Part 2, the hands-on feature manipulation exercise. You must score at least 80% on each part to become certified.

Is the Smartsheet certification exam open book?

Yes. The Core Product Certification is open book, so during the test you can reference the Smartsheet Help Center and the Smartsheet Community. The exam is also virtually proctored, requiring screen, camera, and location sharing.

How long is the certification valid and how do I renew it?

The Core Product Certification is valid for two years. To stay certified you retake the current edition of the exam before your certification expires, keeping your skills aligned with product updates.

How should I prepare for the Smartsheet Core Product exam?

Smartsheet recommends using the platform consistently for three to six months before testing. Practice column types, formulas with @row and CHILDREN(), reports, dashboard widgets, automation triggers and actions, forms, and the five sharing permission levels.