1
Smartsheet Core Product Certification
Exam (New Update)
Questions and Verified Answers |
100% Correct | Graded A
1. What is the primary function of the Hierarchy Column in a
Smartsheet sheet?
o A. To calculate sums of subtasks
o B. To indent and outline parent-child row relationships
o C. To filter rows by date
o D. To attach files to cells
B. To indent and outline parent-child row relationships
Explanation: The Hierarchy Column uses indentations to visually
represent task dependencies and subtasks, enabling roll-up reporting and
Gantt chart generation, as per Smartsheet's 2025 hierarchy management
updates.
2. Which formula function returns the current date?
o A. TODAY()
o B. NOW()
o C. DATE()
o D. CURRENT()
A. TODAY()
Explanation: TODAY() dynamically inserts the current date without
time, ideal for due date tracking; NOW() includes time, per Smartsheet
formula reference for date functions.
, 2
3. In a scenario where a project manager needs to automate
notifications when a task status changes to "Complete," which
feature should be used?
o A. Conditional Formatting
o B. Automation Workflow
o C. Dashboard Metrics
o D. Form Submission
B. Automation Workflow
Explanation: Automations trigger alerts based on cell changes,
streamlining communication; configured via the Automation tab for
status updates in 2025 workflows.
4. What is the maximum number of rows allowed in a standard
Smartsheet plan?
o A. 1,000
o B. 5,000
o C. 20,000
o D. Unlimited
C. 20,000
Explanation: Smartsheet supports up to 20,000 rows per sheet in
Business plans as of 2026 updates, ensuring scalability for large
projects.
5. Which cell type cannot contain formulas?
o A. Text/Number
o B. Date
o C. Dropdown (Single Select)
o D. Contact List
C. Dropdown (Single Select)
Explanation: Dropdown cells are restricted to predefined values for
data consistency; formulas require Text/Number or compatible types.
Smartsheet Core Product Certification
Exam (New Update)
Questions and Verified Answers |
100% Correct | Graded A
1. What is the primary function of the Hierarchy Column in a
Smartsheet sheet?
o A. To calculate sums of subtasks
o B. To indent and outline parent-child row relationships
o C. To filter rows by date
o D. To attach files to cells
B. To indent and outline parent-child row relationships
Explanation: The Hierarchy Column uses indentations to visually
represent task dependencies and subtasks, enabling roll-up reporting and
Gantt chart generation, as per Smartsheet's 2025 hierarchy management
updates.
2. Which formula function returns the current date?
o A. TODAY()
o B. NOW()
o C. DATE()
o D. CURRENT()
A. TODAY()
Explanation: TODAY() dynamically inserts the current date without
time, ideal for due date tracking; NOW() includes time, per Smartsheet
formula reference for date functions.
, 2
3. In a scenario where a project manager needs to automate
notifications when a task status changes to "Complete," which
feature should be used?
o A. Conditional Formatting
o B. Automation Workflow
o C. Dashboard Metrics
o D. Form Submission
B. Automation Workflow
Explanation: Automations trigger alerts based on cell changes,
streamlining communication; configured via the Automation tab for
status updates in 2025 workflows.
4. What is the maximum number of rows allowed in a standard
Smartsheet plan?
o A. 1,000
o B. 5,000
o C. 20,000
o D. Unlimited
C. 20,000
Explanation: Smartsheet supports up to 20,000 rows per sheet in
Business plans as of 2026 updates, ensuring scalability for large
projects.
5. Which cell type cannot contain formulas?
o A. Text/Number
o B. Date
o C. Dropdown (Single Select)
o D. Contact List
C. Dropdown (Single Select)
Explanation: Dropdown cells are restricted to predefined values for
data consistency; formulas require Text/Number or compatible types.
