SMARTSHEET CORE PRODUCT CERTIFICATION
EXAM NEWEST 2024 COMPLETE 100 QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+
Jason is managing a new project and created a sheet to track its status. The project charter was just
approved by his stakeholders. It is a PDF document.
What is the recommended way to include it in Smartsheet? - CORRECT ANSWER-Attach the file to the
sheet
How can you make sure that a specific collaborator receives a notification about a comment that you
make? - CORRECT ANSWER-Mention them with the @ symbol in the comment
Shawn is managing a project that includes a subcontractor. His sheet contains sensitive budget data that
he does not want the subcontractor to view.
How can Shawn have the subcontractor make updates to his project sheet? - CORRECT ANSWER-Send
an update request
Maria manages requests for a marketing shared services team. She has separate sheets to track new
requests, projects that are in progress, and archived requests.
What is the recommended way to share these assets with her team? - CORRECT ANSWER-Put them in a
workspace
You created a workspace to organize a program you manage. Inez told you that she has a few sheets to
add to the workspace.
What permission does she need for her to be able to move these sheets into your workspace? -
CORRECT ANSWER-Admin
After returning from a week of vacation, you want to see what changes have been made to your sheet.
How can you see all the cells that have changed? - CORRECT ANSWER-Highlight changes
You shared a sheet with Javier and gave him Admin permission. You then moved the sheet into a
workspace that Javier has Viewer permission to.
, What permission level does Javier have on the sheet? - CORRECT ANSWER-Admin
Your project team is having a dispute about when a task was marked as complete.
How can you solve the dispute? - CORRECT ANSWER-Check the Cell History
The sponsor of a project that you are managing wants an emailed update on the status of the project
before their weekly meeting.
How can you ensure they have an up-to-date view of the project sheet in their inbox each week? -
CORRECT ANSWER-Schedule the sheet to send weekly as an attachment
How can you provide access to a form? - CORRECT ANSWER-Email the form directly from Smartsheet
What is the lowest permission you need to create a form? - CORRECT ANSWER-Admin
Which can you customize with a color of your choice? - CORRECT ANSWER-Background
Pamela is creating a form to collect requests for her marketing creative services team. In order to
complete any request, she needs to know which cost center to bill for the work. How can she ensure
that each request will contain the cost center? - CORRECT ANSWER-Make the field required
Which column records when a form was submitted? - CORRECT ANSWER-Created (Date)
What information is tracked in the Attachments Summary? - CORRECT ANSWER-File name
Date Attached
Name of the individual who attached the files
When entering formulas in Smartsheet, cell references use the syntax of column name and row number.
What symbol must be placed around a column name when it includes a space, special characters or
number?
{ } Curly brackets
EXAM NEWEST 2024 COMPLETE 100 QUESTIONS
AND CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+
Jason is managing a new project and created a sheet to track its status. The project charter was just
approved by his stakeholders. It is a PDF document.
What is the recommended way to include it in Smartsheet? - CORRECT ANSWER-Attach the file to the
sheet
How can you make sure that a specific collaborator receives a notification about a comment that you
make? - CORRECT ANSWER-Mention them with the @ symbol in the comment
Shawn is managing a project that includes a subcontractor. His sheet contains sensitive budget data that
he does not want the subcontractor to view.
How can Shawn have the subcontractor make updates to his project sheet? - CORRECT ANSWER-Send
an update request
Maria manages requests for a marketing shared services team. She has separate sheets to track new
requests, projects that are in progress, and archived requests.
What is the recommended way to share these assets with her team? - CORRECT ANSWER-Put them in a
workspace
You created a workspace to organize a program you manage. Inez told you that she has a few sheets to
add to the workspace.
What permission does she need for her to be able to move these sheets into your workspace? -
CORRECT ANSWER-Admin
After returning from a week of vacation, you want to see what changes have been made to your sheet.
How can you see all the cells that have changed? - CORRECT ANSWER-Highlight changes
You shared a sheet with Javier and gave him Admin permission. You then moved the sheet into a
workspace that Javier has Viewer permission to.
, What permission level does Javier have on the sheet? - CORRECT ANSWER-Admin
Your project team is having a dispute about when a task was marked as complete.
How can you solve the dispute? - CORRECT ANSWER-Check the Cell History
The sponsor of a project that you are managing wants an emailed update on the status of the project
before their weekly meeting.
How can you ensure they have an up-to-date view of the project sheet in their inbox each week? -
CORRECT ANSWER-Schedule the sheet to send weekly as an attachment
How can you provide access to a form? - CORRECT ANSWER-Email the form directly from Smartsheet
What is the lowest permission you need to create a form? - CORRECT ANSWER-Admin
Which can you customize with a color of your choice? - CORRECT ANSWER-Background
Pamela is creating a form to collect requests for her marketing creative services team. In order to
complete any request, she needs to know which cost center to bill for the work. How can she ensure
that each request will contain the cost center? - CORRECT ANSWER-Make the field required
Which column records when a form was submitted? - CORRECT ANSWER-Created (Date)
What information is tracked in the Attachments Summary? - CORRECT ANSWER-File name
Date Attached
Name of the individual who attached the files
When entering formulas in Smartsheet, cell references use the syntax of column name and row number.
What symbol must be placed around a column name when it includes a space, special characters or
number?
{ } Curly brackets
