SMARTSHEET CERTIFICATION VERIFIED EXAM SOLUTIONS -
COMPREHENSIVE QUESTIONS AND ANSWERS - CURRENT
VERSION
Q1. What is the maximum number of rows allowed in a single
Smartsheet? ANSWER 20,000 rows.
Q2. What is the maximum number of columns allowed in a single
Smartsheet? ANSWER 400 columns.
Q3. What happens when you convert a row to a card on a board?
ANSWER The row data is displayed as a visual card, but the underlying
row remains in the grid.
Q4. What is a "Sheet Summary" used for? ANSWER To store key
metrics, values, and fields at the sheet level that can be referenced in
formulas and dashboards.
Q5. Can you create cross-sheet references using Sheet Summary
fields? ANSWER Yes, Sheet Summary fields can be referenced in
formulas and used in metrics widgets on dashboards.
Q6. What is the purpose of the Gantt view? ANSWER To visualize
project timelines, task dependencies, and durations in a bar-chart format.
Q7. What must be enabled to use the Gantt view? ANSWER
Dependencies must be enabled in the Project Settings.
Q8. What happens when dependencies are enabled? ANSWER
Duration, Start Date, End Date, and Predecessors become locked and are
calculated automatically based on relationships.
Q9. What is a "Baseline" in Smartsheet? ANSWER A snapshot of
original schedule data used to compare planned vs. actual progress.
Q10. How do you set a baseline? ANSWER Through Project Settings >
Baselines, after dependencies are enabled.
,Q11. What is the difference between a sheet and a template?
ANSWER A template is a pre-built sheet structure that can be reused; a
sheet contains live data.
Q12. Where can you find pre-built templates in Smartsheet?
ANSWER In the Solution Center, accessible from the left navigation panel.
Q13. What is a "Workspace" in Smartsheet? ANSWER A container that
organizes multiple sheets, reports, and dashboards for a project or team.
Q14. Can you share an entire Workspace? ANSWER Yes, and
permissions applied at the Workspace level apply to all items within it.
Q15. What happens if a user has Admin access to a sheet but Viewer
access via a Workspace? ANSWER The most permissive access level
applies — Admin in this case.
Q16. What is the maximum file size for attachments in Smartsheet?
ANSWER 250 MB per file.
Q17. How many attachments can be added to a single row? ANSWER
There is no specific row-level limit, but the overall sheet storage limit
applies based on plan type.
Q18. What is a "Proof" in Smartsheet? ANSWER A feature for
reviewing and approving files with markup, comments, and version
tracking.
Q19. What file types can be used for Proofs? ANSWER Images, PDFs,
Microsoft Office files, and video files.
Q20. What is the purpose of the Card View? ANSWER To display rows
as cards organized by lanes (e.g., status, assignee) for agile or Kanban-
style project management.
Q21. Can Card View lanes be customized? ANSWER Yes, lanes can be
based on any dropdown list or contact column.
Q22. What is the Calendar view used for? ANSWER To display tasks
and dates on a monthly or weekly calendar.
Q23. What date columns are required for the Calendar view?
ANSWER At least one date column must be present in the sheet.
, Q24. What is "Conditional Formatting" in Smartsheet? ANSWER Rules
that automatically change the background color, font, or formatting of
rows or cells based on criteria.
Q25. How many conditional formatting rules can a sheet have?
ANSWER Up to 100 conditional formatting rules per sheet.
Q26. What is a "Hierarchy" in Smartsheet? ANSWER Parent-child
relationships between rows that allow for roll-up calculations and
collapsible sections.
Q27. How do you create a parent row? ANSWER Indent one or more
rows beneath another row using the indent button or Tab key.
Q28. What functions can roll up child row data to parent rows?
ANSWER Functions like SUM, AVG, COUNT, and their CHILDREN variants.
Q29. What is the "Critical Path" in a Gantt chart? ANSWER The
sequence of tasks that determines the shortest possible project duration;
delays here delay the entire project.
Q30. How do you display the Critical Path? ANSWER In Gantt view,
click the gear icon and select "Show Critical Path."**
SECTION 2: COLUMNS & DATA TYPES (Q31–Q50)
Q31. What are the available column types in Smartsheet? ANSWER
Text/Number, Date, Dropdown List, Checkbox, Contact List, Symbol, Auto-
Number/System, and Predecessor.
Q32. What is a "Contact List" column used for? ANSWER To assign
people to tasks, send notifications, and track ownership.
Q33. Can a Contact List column allow multiple contacts per cell?
ANSWER Yes, if the "Allow multiple contacts per cell" option is enabled.
Q34. What is an "Auto-Number" column? ANSWER A system column
that automatically generates unique identifiers (e.g., ID numbers) for each
row.
Q35. What formats are available for Auto-Number columns?
ANSWER Number only, prefix + number, date + number, and custom
combinations.
COMPREHENSIVE QUESTIONS AND ANSWERS - CURRENT
VERSION
Q1. What is the maximum number of rows allowed in a single
Smartsheet? ANSWER 20,000 rows.
Q2. What is the maximum number of columns allowed in a single
Smartsheet? ANSWER 400 columns.
Q3. What happens when you convert a row to a card on a board?
ANSWER The row data is displayed as a visual card, but the underlying
row remains in the grid.
Q4. What is a "Sheet Summary" used for? ANSWER To store key
metrics, values, and fields at the sheet level that can be referenced in
formulas and dashboards.
Q5. Can you create cross-sheet references using Sheet Summary
fields? ANSWER Yes, Sheet Summary fields can be referenced in
formulas and used in metrics widgets on dashboards.
Q6. What is the purpose of the Gantt view? ANSWER To visualize
project timelines, task dependencies, and durations in a bar-chart format.
Q7. What must be enabled to use the Gantt view? ANSWER
Dependencies must be enabled in the Project Settings.
Q8. What happens when dependencies are enabled? ANSWER
Duration, Start Date, End Date, and Predecessors become locked and are
calculated automatically based on relationships.
Q9. What is a "Baseline" in Smartsheet? ANSWER A snapshot of
original schedule data used to compare planned vs. actual progress.
Q10. How do you set a baseline? ANSWER Through Project Settings >
Baselines, after dependencies are enabled.
,Q11. What is the difference between a sheet and a template?
ANSWER A template is a pre-built sheet structure that can be reused; a
sheet contains live data.
Q12. Where can you find pre-built templates in Smartsheet?
ANSWER In the Solution Center, accessible from the left navigation panel.
Q13. What is a "Workspace" in Smartsheet? ANSWER A container that
organizes multiple sheets, reports, and dashboards for a project or team.
Q14. Can you share an entire Workspace? ANSWER Yes, and
permissions applied at the Workspace level apply to all items within it.
Q15. What happens if a user has Admin access to a sheet but Viewer
access via a Workspace? ANSWER The most permissive access level
applies — Admin in this case.
Q16. What is the maximum file size for attachments in Smartsheet?
ANSWER 250 MB per file.
Q17. How many attachments can be added to a single row? ANSWER
There is no specific row-level limit, but the overall sheet storage limit
applies based on plan type.
Q18. What is a "Proof" in Smartsheet? ANSWER A feature for
reviewing and approving files with markup, comments, and version
tracking.
Q19. What file types can be used for Proofs? ANSWER Images, PDFs,
Microsoft Office files, and video files.
Q20. What is the purpose of the Card View? ANSWER To display rows
as cards organized by lanes (e.g., status, assignee) for agile or Kanban-
style project management.
Q21. Can Card View lanes be customized? ANSWER Yes, lanes can be
based on any dropdown list or contact column.
Q22. What is the Calendar view used for? ANSWER To display tasks
and dates on a monthly or weekly calendar.
Q23. What date columns are required for the Calendar view?
ANSWER At least one date column must be present in the sheet.
, Q24. What is "Conditional Formatting" in Smartsheet? ANSWER Rules
that automatically change the background color, font, or formatting of
rows or cells based on criteria.
Q25. How many conditional formatting rules can a sheet have?
ANSWER Up to 100 conditional formatting rules per sheet.
Q26. What is a "Hierarchy" in Smartsheet? ANSWER Parent-child
relationships between rows that allow for roll-up calculations and
collapsible sections.
Q27. How do you create a parent row? ANSWER Indent one or more
rows beneath another row using the indent button or Tab key.
Q28. What functions can roll up child row data to parent rows?
ANSWER Functions like SUM, AVG, COUNT, and their CHILDREN variants.
Q29. What is the "Critical Path" in a Gantt chart? ANSWER The
sequence of tasks that determines the shortest possible project duration;
delays here delay the entire project.
Q30. How do you display the Critical Path? ANSWER In Gantt view,
click the gear icon and select "Show Critical Path."**
SECTION 2: COLUMNS & DATA TYPES (Q31–Q50)
Q31. What are the available column types in Smartsheet? ANSWER
Text/Number, Date, Dropdown List, Checkbox, Contact List, Symbol, Auto-
Number/System, and Predecessor.
Q32. What is a "Contact List" column used for? ANSWER To assign
people to tasks, send notifications, and track ownership.
Q33. Can a Contact List column allow multiple contacts per cell?
ANSWER Yes, if the "Allow multiple contacts per cell" option is enabled.
Q34. What is an "Auto-Number" column? ANSWER A system column
that automatically generates unique identifiers (e.g., ID numbers) for each
row.
Q35. What formats are available for Auto-Number columns?
ANSWER Number only, prefix + number, date + number, and custom
combinations.
