Smartsheet Certification Exam
With 100% Score
180 Questions with Proven
Solution
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 - ANSWERS-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 - ANSWERS-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 - ANSWERS-Hidden
Which function leverages sheet hierarchy to
reference the range of rows that are
indented below another row?
ANCESTORS()
CHILDREN()
PARENT()
INDEX() - ANSWERS-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.
With 100% Score
180 Questions with Proven
Solution
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 - ANSWERS-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 - ANSWERS-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 - ANSWERS-Hidden
Which function leverages sheet hierarchy to
reference the range of rows that are
indented below another row?
ANCESTORS()
CHILDREN()
PARENT()
INDEX() - ANSWERS-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.
