SMARTSHEET CORE PRODUCT EXAM QUESTIONS AND ANSWERS 2025
A user opened a report that you shared to them but cannot see any data. Which is a reason that might
occur? - (ANSWER)The user is not shared to any sheets that the report is pulling data from
Adriana is managing a consulting project. She is using Smartsheet to manage this project, but her client
does not use Smartsheet. How can Adriana provide the client access to the live data in her project status
dashboard? - (ANSWER)Publish the dashboard and send the link
After returning from a week of vacation, you want to see what changes have been made to your sheet.
How can you see all of the cells that have changed? - (ANSWER)Highlight Changes
Alex is building a sheet to keep track of her tasks on a website project. She must perform the same set
of tasks for each webpage. She listed each webpage on her sheet and has written out the tasks for the
first one.
What is the fastest way for her to add the tasks to the remaining webpages? - (ANSWER)Copy the rows
with tasks, then paste them under each webpage
Andy created a report for a member of his team, Bill, to see his tasks in one place. He now needs to
create a similar report for another team member, Candace. What should Andy's first step be? -
(ANSWER)Save Bill's report as a new report
Bobbi has 3 sheets that she uses to manage different categories of purchase requests for her
procurement team. The procurement director needs to see the combined value of approved requests
across all categories. How can Bobbi display this value? - (ANSWER)Create a report to combine approved
requests, then summarize the values using SUM
Faisal is managing a project in a sheet. He has a symbol column to track tasks that are at risk. When a
task becomes at risk, he wants to immediately notify the person assigned to the task. How could he do
this? - (ANSWER)Create an alert to notify the assignee when a task is marked at risk
Fatima manages several projects for her IT group. Each project has a sheet that she keeps in separate
folders in a workspace that she owns. She built a summary report to communicate project status metrics
to her leadership team. What can she do to avoid having to manually add each new sheet as a source for
the report? - (ANSWER)Use the workspace as the data source for the report
, SMARTSHEET CORE PRODUCT EXAM QUESTIONS AND ANSWERS 2025
Guillermo owns a project tracking sheet. His sheet uses a hierarchy with all tasks being children of a
phase. He created a filter to help his team see only their tasks. They are reporting that it is difficult to
understand the phase as there are tasks with the same name in multiple phases. To help them
understand the phase, he has added a column titled "Phase." What function can he combine with JOIN()
to show this information? - (ANSWER)ANCESTORS()
How can a user modify a report to get different results? - (ANSWER)Change the filter criteria
How can you make sure that a specific collaborator receives a notification about a comment that you
make? - (ANSWER)Mention them with the @ symbol in the comment
How can you provide access to a form? - (ANSWER)Email the form directly from Smartsheet
How do you reference the red ball in a symbol column in a formula? - (ANSWER)"Red"
How is embedding a form on a dashboard via the web content widget effective? - (ANSWER)It allows an
individual to complete a form submission without leaving the dashboard
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? - (ANSWER)Attach the file to the sheet
Jean is building a workflow to remind collaborators to update their project status each week. They want
to change the message if a project is past due. What is the most efficient way for them to do this? -
(ANSWER)Add a conditional path with a second action
Jennifer is building a sheet to calculate commissions for her sales team. They earn a fixed percentage of
each sale they make. She has entered the commission rate in a cell on her sheet. Which formula can
Jennifer copy and paste into each row to correctly calculate her team's commissions? -
(ANSWER)=SUM([Opportunity Value]@row * [Commission Rate]$1)
A user opened a report that you shared to them but cannot see any data. Which is a reason that might
occur? - (ANSWER)The user is not shared to any sheets that the report is pulling data from
Adriana is managing a consulting project. She is using Smartsheet to manage this project, but her client
does not use Smartsheet. How can Adriana provide the client access to the live data in her project status
dashboard? - (ANSWER)Publish the dashboard and send the link
After returning from a week of vacation, you want to see what changes have been made to your sheet.
How can you see all of the cells that have changed? - (ANSWER)Highlight Changes
Alex is building a sheet to keep track of her tasks on a website project. She must perform the same set
of tasks for each webpage. She listed each webpage on her sheet and has written out the tasks for the
first one.
What is the fastest way for her to add the tasks to the remaining webpages? - (ANSWER)Copy the rows
with tasks, then paste them under each webpage
Andy created a report for a member of his team, Bill, to see his tasks in one place. He now needs to
create a similar report for another team member, Candace. What should Andy's first step be? -
(ANSWER)Save Bill's report as a new report
Bobbi has 3 sheets that she uses to manage different categories of purchase requests for her
procurement team. The procurement director needs to see the combined value of approved requests
across all categories. How can Bobbi display this value? - (ANSWER)Create a report to combine approved
requests, then summarize the values using SUM
Faisal is managing a project in a sheet. He has a symbol column to track tasks that are at risk. When a
task becomes at risk, he wants to immediately notify the person assigned to the task. How could he do
this? - (ANSWER)Create an alert to notify the assignee when a task is marked at risk
Fatima manages several projects for her IT group. Each project has a sheet that she keeps in separate
folders in a workspace that she owns. She built a summary report to communicate project status metrics
to her leadership team. What can she do to avoid having to manually add each new sheet as a source for
the report? - (ANSWER)Use the workspace as the data source for the report
, SMARTSHEET CORE PRODUCT EXAM QUESTIONS AND ANSWERS 2025
Guillermo owns a project tracking sheet. His sheet uses a hierarchy with all tasks being children of a
phase. He created a filter to help his team see only their tasks. They are reporting that it is difficult to
understand the phase as there are tasks with the same name in multiple phases. To help them
understand the phase, he has added a column titled "Phase." What function can he combine with JOIN()
to show this information? - (ANSWER)ANCESTORS()
How can a user modify a report to get different results? - (ANSWER)Change the filter criteria
How can you make sure that a specific collaborator receives a notification about a comment that you
make? - (ANSWER)Mention them with the @ symbol in the comment
How can you provide access to a form? - (ANSWER)Email the form directly from Smartsheet
How do you reference the red ball in a symbol column in a formula? - (ANSWER)"Red"
How is embedding a form on a dashboard via the web content widget effective? - (ANSWER)It allows an
individual to complete a form submission without leaving the dashboard
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? - (ANSWER)Attach the file to the sheet
Jean is building a workflow to remind collaborators to update their project status each week. They want
to change the message if a project is past due. What is the most efficient way for them to do this? -
(ANSWER)Add a conditional path with a second action
Jennifer is building a sheet to calculate commissions for her sales team. They earn a fixed percentage of
each sale they make. She has entered the commission rate in a cell on her sheet. Which formula can
Jennifer copy and paste into each row to correctly calculate her team's commissions? -
(ANSWER)=SUM([Opportunity Value]@row * [Commission Rate]$1)
