Smartsheet Core Product Certification Exam Prep
2024/2025 - 80 Practice Questions & Verified
Answers
SECTION A. SHEET MANAGEMENT & FUNDAMENTALS (15 QUESTIONS)
A1. Sheet Creation, Templates, Basic Formatting (5 Q)
Q1.
A project manager needs to spin up a new project tracker that uses the same column
structure, conditional-formatting rules, and sheet-level settings as an existing
"Marketing Campaign" sheet but must NOT retain any rows. Which command sequence
accomplishes this in the fewest clicks?
A. File → Create New → Blank Sheet → Copy/Paste columns manually
B. Right-click existing sheet → Save as New → Check "Sheet structure only"
C. Home → Create → From Template → Search "Marketing Campaign"
D. File → Import → Excel → Upload a cleaned file
Answer: B – Right-click existing sheet → Save as New → Check "Sheet structure only"
Rationale: "Save as New" with the "Sheet structure only" checkbox (introduced 2023-Q4)
copies formatting, formulas, validation, and automation without rows—perfect for clean
templates. Option C imports rows unless you delete them afterwards.
Q2.
,Which sheet-level setting must be enabled before you can apply alternating-row banding
(striping) to a grid?
A. Allow multiple users per row
B. Display in card view
C. Use column formulas
D. None—striping is available by default
Answer: D – None—striping is available by default
Rationale: Row banding lives under Format → Alternating Row Color and requires no
prerequisite toggles; it is purely cosmetic and user-specific.
Q3.
SATA. Saving a personal template to the Smartsheet gallery makes which elements
portable for other licensed users? (Select all that apply.)
A. Column structures & types
B. Conditional-formatting rules
C. Row-level attachments
D. Sheet-level and column-level formulas
E. Published dashboard links
Answers: A, B, D – Column structures, conditional-formatting rules, and formulas are
retained; row attachments (C) and external dashboard links (E) are excluded to keep
templates lightweight and secure.
,Q4.
The default currency format in a new sheet created from a US-locale account is:
A. USD with two decimal places
B. USD with zero decimal places
C. No format until changed by user
D. Determined by system admin locale
Answer: A – USD with two decimal places
Rationale: Smartsheet auto-applies locale-based currency (USD, two decimals) to
Currency-type columns; users can override per column.
Q5.
Which action is prevented when "Lock Row" is applied?
A. Editing any cell in that row
B. Deleting the row
C. Moving the row via drag-and-drop
D. Both B and C
Answer: D – Both B and C
Rationale: Locking prevents deletion and reordering; cell editing is still allowed unless
the sheet is locked or user lacks Editor permissions.
, A2. Column Types & Data Validation (4 Q)
Q6.
A team wants to restrict date entries to only weekdays (Mon–Fri) for a "Start Date"
column. The most native Smartsheet method is:
A. Formula in a helper column flagging weekends
B. Date column + weekday validation rule
C. Form logic hiding weekend choices
D. There is no built-in weekday filter
Answer: B – Date column + weekday validation rule
Rationale: Column Properties → Validation → Custom → "Weekday Only" (2024 feature)
blocks weekend dates at entry; no helper column needed.
Q7.
A Contact List column is configured with "Restrict to list values only." Which statement
is TRUE?
A. Users can still type any email outside the list
B. Only pre-added contacts appear; free-text emails are blocked
C. Form submissions bypass the restriction
D. The restriction applies only to Card View
Answer: B – Only pre-added contacts appear; free-text emails are blocked
2024/2025 - 80 Practice Questions & Verified
Answers
SECTION A. SHEET MANAGEMENT & FUNDAMENTALS (15 QUESTIONS)
A1. Sheet Creation, Templates, Basic Formatting (5 Q)
Q1.
A project manager needs to spin up a new project tracker that uses the same column
structure, conditional-formatting rules, and sheet-level settings as an existing
"Marketing Campaign" sheet but must NOT retain any rows. Which command sequence
accomplishes this in the fewest clicks?
A. File → Create New → Blank Sheet → Copy/Paste columns manually
B. Right-click existing sheet → Save as New → Check "Sheet structure only"
C. Home → Create → From Template → Search "Marketing Campaign"
D. File → Import → Excel → Upload a cleaned file
Answer: B – Right-click existing sheet → Save as New → Check "Sheet structure only"
Rationale: "Save as New" with the "Sheet structure only" checkbox (introduced 2023-Q4)
copies formatting, formulas, validation, and automation without rows—perfect for clean
templates. Option C imports rows unless you delete them afterwards.
Q2.
,Which sheet-level setting must be enabled before you can apply alternating-row banding
(striping) to a grid?
A. Allow multiple users per row
B. Display in card view
C. Use column formulas
D. None—striping is available by default
Answer: D – None—striping is available by default
Rationale: Row banding lives under Format → Alternating Row Color and requires no
prerequisite toggles; it is purely cosmetic and user-specific.
Q3.
SATA. Saving a personal template to the Smartsheet gallery makes which elements
portable for other licensed users? (Select all that apply.)
A. Column structures & types
B. Conditional-formatting rules
C. Row-level attachments
D. Sheet-level and column-level formulas
E. Published dashboard links
Answers: A, B, D – Column structures, conditional-formatting rules, and formulas are
retained; row attachments (C) and external dashboard links (E) are excluded to keep
templates lightweight and secure.
,Q4.
The default currency format in a new sheet created from a US-locale account is:
A. USD with two decimal places
B. USD with zero decimal places
C. No format until changed by user
D. Determined by system admin locale
Answer: A – USD with two decimal places
Rationale: Smartsheet auto-applies locale-based currency (USD, two decimals) to
Currency-type columns; users can override per column.
Q5.
Which action is prevented when "Lock Row" is applied?
A. Editing any cell in that row
B. Deleting the row
C. Moving the row via drag-and-drop
D. Both B and C
Answer: D – Both B and C
Rationale: Locking prevents deletion and reordering; cell editing is still allowed unless
the sheet is locked or user lacks Editor permissions.
, A2. Column Types & Data Validation (4 Q)
Q6.
A team wants to restrict date entries to only weekdays (Mon–Fri) for a "Start Date"
column. The most native Smartsheet method is:
A. Formula in a helper column flagging weekends
B. Date column + weekday validation rule
C. Form logic hiding weekend choices
D. There is no built-in weekday filter
Answer: B – Date column + weekday validation rule
Rationale: Column Properties → Validation → Custom → "Weekday Only" (2024 feature)
blocks weekend dates at entry; no helper column needed.
Q7.
A Contact List column is configured with "Restrict to list values only." Which statement
is TRUE?
A. Users can still type any email outside the list
B. Only pre-added contacts appear; free-text emails are blocked
C. Form submissions bypass the restriction
D. The restriction applies only to Card View
Answer: B – Only pre-added contacts appear; free-text emails are blocked
