SMARTSHEET PROJECT MANAGEMENT
CERTIFICATION 2026 COMPLETE STUDY
GUIDE AND PRACTICE QUESTIONS
◉ Steps: Adding conditional logic to forms. Answer: Create form
Choose source field
Logic>Add logic
When ____ , Then _____
◉ Preview form. Answer: open form
◉ Streamline form submission data. Answer: Create intake only
sheet, new data populates at the bottom of the sheet
◉ CAN import these files. Answer: M Excel
M Project
Google sheet
Atlassian Trello
◉ Imported files cannot .... Answer: over 50 mb
over 20,000 rows, 400 columns, 500,000 cells
, *formulas are not preserved*`
◉ Gantt view allows you to see. Answer: Duration
view dependencies
view critical path
view % complete
◉ To use Gantt view, the sheet must have .... Answer: 2 date columns
◉ WBS. Answer: Work breakdown structures
◉ WBS steps. Answer: Project > Phases > Deliverables > Tasks
◉ When dependencies are activated. Answer: changes in start and
end dates automatically adjust and calculate the third value
◉ SD, ED, Duration, and % complete automatically. Answer: rollup to
the parent rows
◉ Parent rows are. Answer: read only
highlight the critical path
CERTIFICATION 2026 COMPLETE STUDY
GUIDE AND PRACTICE QUESTIONS
◉ Steps: Adding conditional logic to forms. Answer: Create form
Choose source field
Logic>Add logic
When ____ , Then _____
◉ Preview form. Answer: open form
◉ Streamline form submission data. Answer: Create intake only
sheet, new data populates at the bottom of the sheet
◉ CAN import these files. Answer: M Excel
M Project
Google sheet
Atlassian Trello
◉ Imported files cannot .... Answer: over 50 mb
over 20,000 rows, 400 columns, 500,000 cells
, *formulas are not preserved*`
◉ Gantt view allows you to see. Answer: Duration
view dependencies
view critical path
view % complete
◉ To use Gantt view, the sheet must have .... Answer: 2 date columns
◉ WBS. Answer: Work breakdown structures
◉ WBS steps. Answer: Project > Phases > Deliverables > Tasks
◉ When dependencies are activated. Answer: changes in start and
end dates automatically adjust and calculate the third value
◉ SD, ED, Duration, and % complete automatically. Answer: rollup to
the parent rows
◉ Parent rows are. Answer: read only
highlight the critical path