-
Getting Started
-
Core Product Exam ai_proctored
Core Product Certification Exam
Take the exam now to verify your Core Product skills!
Please Note: You must complete the certification exam within 60 days of purchasing the exam. Please be sure to review the exam resources and study guide before registering for the exam.
The Core Product Certified exam validates that candidates can build and configure collaborative work environments. Candidates should have an overall knowledge of the Core Product independent of a specific job role. Candidates should be able to create and organize information within a sheet, create and implement automated workflows, write formulas, build forms, and create and deploy reports and dashboards.
Qualified Candidate Description
Qualified candidates are licensed users that understand the data structure and labeling within Smartsheet. They are able to work with templates and can build simple solutions from scratch. They use formulas with well formed references and are comfortable with basic automation to communicate with team members and stakeholders.
Additionally the candidate should haveat least 3-6 months experience with the core product.
Exam Details
- Content: 65 multiple-choice questions (60 scored and 5 unscored)
- Time to complete the exam: 90 minutes
- Delivery: Proctored exam and must agree to be recorded per the Smartsheet Certified Candidate Agreement
- References: No hard-copy or online materials may be referenced during the exam.
- Prerequisite: None required; Core App Skills Paths (Instructor-led or eLearning) highly recommended
- Resources: Core Product Certification Resources
Exam Content
Domain 1 Sheets (16%, 10 questions)
- 01.01 Create a new sheet or import a sheet from MS Excel, MS Project, Google Sheets or Atlassian Trello
- 01.02 Create and manage columns to categorize data and optimize the display
- 01.03 Format the appearance of cells to improve readability
- 01.04 Add links and images for easy access by team members
- 01.05 Use conditional formatting to highlight rows or cells based on specified criteria
- 01.06 Create and use filters to display rows based on specific conditions
- 01.07 Input and organize data within a sheet (eg, cell-linking, hierarchy, sheet summary)
- 01.08 Export, publish, or print a sheet to share data with a broader audience
- 01.09 Display data in different views to communicate with various team members ie Gantt with stakeholders, calendar with team leads, card with team members
Domain 2: Collaboration (15%, 9 Questions)
- 02.01 Create and share a workspace or sheet
- 02.02 Demonstrate understanding of when to create a new workspace or a subfolder within an existing workspace
- 02.03 Assign permissions for a workspace and a sheet within that workspace to ensure that collaborators have appropriate access
- 02.04 Add a comment to a row, cell, or sheet to start a conversation
- 02.05 Add comments to existing conversations
- 02.06 Add attachments to a row or a sheet to make files accessible
- 02.07 Add attachments within size and volume limits
- 02.08 Use available functions to track sheet changes over time (eg, highlight, cell history, activity log)
- 02.09 Create and send row data and update requests to collaborators not shared to the sheet
Domain 3: Automation (8.6%, 5 Questions)
- 03.01 Determine the appropriate workflow to use for a given set of actions (eg, alerts/reminders, approval requests, move/copy rows)
- 03.02 Create automated workflows using available triggers, frequencies, and permissions
- 03.03 Create sheet-level automations (single or multi level)
- 03.04 Sequence automations and create conditional paths (eg, waiting for response)
- 03.05 Delete, duplicate and disable workflows
Domain 4: Formulas (21.1%, 13 Questions)
- 04.01 Use absolute vs relative cell referencing in a formula
- 04.02 Use correct format to reference cells
- 04.03 Write formulas using basic operators, including accessing data from/pushing data to sheet summary fields
- 04.04 Convert between cell and column formulas
- 04.05 Use cross-sheet formulas to reference data between multiple sheets
- 04.06 Troubleshoot formulas that aren't functioning correctly
- 04.07 Write SUM and COUNT formulas
- 04.08 Write formulas to calculate data or automate aspects of a sheet based on the hierarchy (ie, PARENT(), CHILDREN(), ANCESTORS())
- 04.09 Use the JOIN formula to include parent row data in reports
- 04.10 Write formulas that use ranges and criterion (eg, SUMIF(), COUNTIF())
- 04.11 Write formulas using IF() and nested IF()s to update symbol columns and drop-down lists
- 04.12 Use the TODAY function to reference the current date
Domain 5: Forms (12.3%, 7 Questions)
- 05.01 Design effective sheet columns for form fields
- 05.02 Organize and hide fields on the form
- 05.03 Assign field settings on a form (eg, default values, required fields)
- 05.04 Adjust form security settings to limit access to the form
- 05.05 Apply custom branding
- 05.06 Share forms with internal and external users
- 05.07 Use system columns to track submission data
Domain 6: Reports (19.2%, 12 Questions)
- 06.01 Create a filtered view of data from multiple sheets
- 06.02 Link multiple sheets, a folder, or a workspace to a report
- 06.03 Group and summarize rows to display totals, counts, etc
- 06.04 Understand the difference between a summary report and a row report
- 06.05 Create a report that only shows data relevant to the current user
- 06.06 Modify the layout of the report (eg, column names, column sequence)
- 06.07 Copy an existing report to use as a basis for additional reports
- 06.08 Create and schedule a report to send as an attachment
- 06.09 Create editable reports that allow recipients to update information on the sheet
- 06.10 Publish reports to share with external stakeholders
- 06.11 Share reports with internal stakeholders
Domain 7: Dashboards; (7.1%, 4 Questions)
- 07.01 Plan and build a dashboard to communicate data to stakeholders
- 07.02 Insert and customize widgets including reports, charts, image, rich text, shortcuts, web content, etc
- 07.03 Share and publish dashboards to make data available to stakeholders
- 07.04 Prepare dashboards to use in presentations (eg, print to pdf, switch to presentation mode)
Exam results
The Core Product Certified exam is a pass or fail exam. The exam results are reported as an overall score and a breakdown by domain. The exam uses a compensatory scoring model, which means that you do not need to achieve a passing score in each section. You need to pass only the overall exam. An overall score of 73 (44/60) is required to pass the exam.
Each section of the exam has a specific weighting, so some sections have more questions than others. The score report contains general information that highlights your strengths and weaknesses. Use caution when interpreting section-level feedback.
Scores specific to questions will not be reported.
Scores will be displayed at the end of the exam, and you can choose to print or email your score report. Scores cannot be used to evaluate against other candidates.
