SMARTSHEET PRACTICE EXAM 2024-2025 QUESTIONS AND
ANSWERS 100 % PASS SOLUTION A+ GRADE
You are using Smartsheet to plan, track and manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a decision on whether to use multiple
single contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple
contact list columns?
When you want to create a filter for each individual
When some individuals are inside your team's account and others are not When you want to
pull a report from a sheet
When the individuals have different roles related to a task - ANSWER- When the individuals
have different roles related to a task
Jen has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Jen's sheet?
Editor- can't share Viewer
Admin
Editor- can share - ANSWER-Admin
When creating a form, using a field, allows you to input a default value into a column on a
sheet without requiring the form submitter to create it.
Branded Hidden Custom
Required - ANSWER-Hidden
Which function leverages sheet hierarchy to reference the range of rows that are indented
below another row?
ANCESTORS() CHILDREN() PARENT()
INDEX() - ANSWER-Children()
,Juan is currently managing the development of a new product. He has a team of four
individuals with whom he assigns various tasks. Juan wants to quickly see tasks assigned to
each person and reassign tasks as needed. Which of the options below would be the most
efficient way for Juan to accomplish this?
Juan needs to create and use a filter for each assignee and then return to the sheet to
reassign tasks.
Juan needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
Juan needs to build a report for each person on his team. From each of the reports, Juan
would reassign tasks.` - ANSWER-Juan needs to utilize card view to view by the assigned to
contact column. He could then view and reassign accordingly.
What can be added to a dashboard to help users understand the data on a dashboard? -
ANSWER-Text labels
Which option would allow someone to view a report if they are not shared to the underlying
sheet(s)? - ANSWER-Add the report to a dashboard by using the Report Widget
Which file type cannot be uploaded using the image widget? - ANSWER- PDF
Which two views of a row report can be displayed on a dashboard using the report widget? -
ANSWER-Grid, Gantt
, What is the default label for the data in a metric widget? - ANSWER- Column name
Which dashboard widget type would be best to show a live updating budget number of a
project? - ANSWER-Metric
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
Which widget behavior will allow the user to open the underlying sheet or report? -
ANSWER-Open the data sou
Which formula is the most scalable way to count the indented rows under "Carl Jackson",
knowing that you will be adding additional rows within this hierarchy? - ANSWER-
=COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet. What is the syntax
to reference the "Budget Total" field in a formula? - ANSWER-[Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? - ANSWER-Cell(s) in a
sheet
When viewing a sheet, you want to have certain rows grab your attention, visually, if the task
is at risk or past its due date. You can accomplish this by using which feature? - ANSWER-
Conditional formatting
ANSWERS 100 % PASS SOLUTION A+ GRADE
You are using Smartsheet to plan, track and manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a decision on whether to use multiple
single contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple
contact list columns?
When you want to create a filter for each individual
When some individuals are inside your team's account and others are not When you want to
pull a report from a sheet
When the individuals have different roles related to a task - ANSWER- When the individuals
have different roles related to a task
Jen has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Jen's sheet?
Editor- can't share Viewer
Admin
Editor- can share - ANSWER-Admin
When creating a form, using a field, allows you to input a default value into a column on a
sheet without requiring the form submitter to create it.
Branded Hidden Custom
Required - ANSWER-Hidden
Which function leverages sheet hierarchy to reference the range of rows that are indented
below another row?
ANCESTORS() CHILDREN() PARENT()
INDEX() - ANSWER-Children()
,Juan is currently managing the development of a new product. He has a team of four
individuals with whom he assigns various tasks. Juan wants to quickly see tasks assigned to
each person and reassign tasks as needed. Which of the options below would be the most
efficient way for Juan to accomplish this?
Juan needs to create and use a filter for each assignee and then return to the sheet to
reassign tasks.
Juan needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
Juan needs to build a report for each person on his team. From each of the reports, Juan
would reassign tasks.` - ANSWER-Juan needs to utilize card view to view by the assigned to
contact column. He could then view and reassign accordingly.
What can be added to a dashboard to help users understand the data on a dashboard? -
ANSWER-Text labels
Which option would allow someone to view a report if they are not shared to the underlying
sheet(s)? - ANSWER-Add the report to a dashboard by using the Report Widget
Which file type cannot be uploaded using the image widget? - ANSWER- PDF
Which two views of a row report can be displayed on a dashboard using the report widget? -
ANSWER-Grid, Gantt
, What is the default label for the data in a metric widget? - ANSWER- Column name
Which dashboard widget type would be best to show a live updating budget number of a
project? - ANSWER-Metric
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
Which widget behavior will allow the user to open the underlying sheet or report? -
ANSWER-Open the data sou
Which formula is the most scalable way to count the indented rows under "Carl Jackson",
knowing that you will be adding additional rows within this hierarchy? - ANSWER-
=COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet. What is the syntax
to reference the "Budget Total" field in a formula? - ANSWER-[Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? - ANSWER-Cell(s) in a
sheet
When viewing a sheet, you want to have certain rows grab your attention, visually, if the task
is at risk or past its due date. You can accomplish this by using which feature? - ANSWER-
Conditional formatting
