Smartsheet Certification Exam Bundle
2025/2026
BUNDLE AT A GLANCE
● 4 full practice exams (65 questions each) = 260 items
● 40 scenario-based solution-design cases (10 per exam)
● 32 items on 2025-2026 new features (8 per exam)
● 28 advanced automation challenges (7 per exam)
● Every question includes why and how-to with clicks & settings
● Maps 1-to-1 to official Smartsheet Certification Objectives (spring 2026 version)
EXAM 1 – CORE CERTIFICATION PRACTICE
A. Sheet Management Fundamentals (22 Q)
1. Question (Column Type)
You must capture a “check-in” timestamp only when a user marks “Attended”
checkbox. Which column fulfills this without formulas?
A. Modified Date
B. Created Date
C. Auto-number
D. Change-based Date
Answer: D – Change-based Date (2025) triggers on specific field change; needs
no helper formula.
Solution:
● Insert > Change-based Date
● Trigger field = “Attended” checkbox
● Choose “Record date when value changes to Checked”
● Leave “Clear if unchecked” OFF to preserve historical time.
Common Error: Picking Modified Date captures ANY edit (notes, status,
etc.).
2. Scenario – New-hire Tracker
HR receives a Google-Form feed daily. Build a sheet that auto-numbers badges,
, calculates orientation date (Hire+7 workdays), and flags if drug-screen missing.
Outline steps.
Model Solution:
● Enable DataShuttle (Google Forms connector) → map columns →
schedule hourly.
● Auto-number column “Badge_ID” with prefix “NHC-” and no leading zeros.
● Formula column “Orientation_Date”:
=WORKDAY([Hire Date]@row,7)
● Conditional Formatting: Drug-Screen = “Pending” → red background +
alert symbol.
● Alert workflow: when Drug-Screen changes to Pending send once daily to
.
Grading Note: Must mention DataShuttle & WORKDAY (not plain +7).
[… 20 more including hierarchy, filters, import/export …]
B. Collaboration & Sharing (21 Q)
20. Question (Proofing)
External agency uploads 30 mock-ups. Which feature allows in-cell annotation on
PDF without third-party storage?
A. Comment thread
B. Proofing panel (2026)
C. Update request
D. Form attachment
Answer: B – native Proofing (summer 2026) stores file inside Smartsheet.
Solution: Right-click attachment > “Open in Proof” > add pin-comments;
@mention auto-sends email.
21. Question (Publishing)
You need a read-only grid for 2 000 public viewers with daily data refresh but
must hide SSN column. Steps?
Answer:
22. File > Publish > “Publish Current View”
23. Uncheck “SSN” column in picker
24. Enable “Publish latest data daily”
25. Copy embed URL (read-only by default)
Key Point: Publishing respects current filter/hidden columns; no login required.
[… 4 workspace, 3 activity-log …]
2025/2026
BUNDLE AT A GLANCE
● 4 full practice exams (65 questions each) = 260 items
● 40 scenario-based solution-design cases (10 per exam)
● 32 items on 2025-2026 new features (8 per exam)
● 28 advanced automation challenges (7 per exam)
● Every question includes why and how-to with clicks & settings
● Maps 1-to-1 to official Smartsheet Certification Objectives (spring 2026 version)
EXAM 1 – CORE CERTIFICATION PRACTICE
A. Sheet Management Fundamentals (22 Q)
1. Question (Column Type)
You must capture a “check-in” timestamp only when a user marks “Attended”
checkbox. Which column fulfills this without formulas?
A. Modified Date
B. Created Date
C. Auto-number
D. Change-based Date
Answer: D – Change-based Date (2025) triggers on specific field change; needs
no helper formula.
Solution:
● Insert > Change-based Date
● Trigger field = “Attended” checkbox
● Choose “Record date when value changes to Checked”
● Leave “Clear if unchecked” OFF to preserve historical time.
Common Error: Picking Modified Date captures ANY edit (notes, status,
etc.).
2. Scenario – New-hire Tracker
HR receives a Google-Form feed daily. Build a sheet that auto-numbers badges,
, calculates orientation date (Hire+7 workdays), and flags if drug-screen missing.
Outline steps.
Model Solution:
● Enable DataShuttle (Google Forms connector) → map columns →
schedule hourly.
● Auto-number column “Badge_ID” with prefix “NHC-” and no leading zeros.
● Formula column “Orientation_Date”:
=WORKDAY([Hire Date]@row,7)
● Conditional Formatting: Drug-Screen = “Pending” → red background +
alert symbol.
● Alert workflow: when Drug-Screen changes to Pending send once daily to
.
Grading Note: Must mention DataShuttle & WORKDAY (not plain +7).
[… 20 more including hierarchy, filters, import/export …]
B. Collaboration & Sharing (21 Q)
20. Question (Proofing)
External agency uploads 30 mock-ups. Which feature allows in-cell annotation on
PDF without third-party storage?
A. Comment thread
B. Proofing panel (2026)
C. Update request
D. Form attachment
Answer: B – native Proofing (summer 2026) stores file inside Smartsheet.
Solution: Right-click attachment > “Open in Proof” > add pin-comments;
@mention auto-sends email.
21. Question (Publishing)
You need a read-only grid for 2 000 public viewers with daily data refresh but
must hide SSN column. Steps?
Answer:
22. File > Publish > “Publish Current View”
23. Uncheck “SSN” column in picker
24. Enable “Publish latest data daily”
25. Copy embed URL (read-only by default)
Key Point: Publishing respects current filter/hidden columns; no login required.
[… 4 workspace, 3 activity-log …]
