1|Page
Smartsheet Certification Exam Version 1, Smartsheet
Product Certification V1, Smartsheet Test Bank,
Smartsheet Questions and Answers, Smartsheet
Version 1 Exam, Smartsheet Study Guide, Smartsheet
Certification Prep
To assign a task to multiple contacts within a single cell, you
must enable multiple contacts. In what location can this
functionality be enabled?
In the Automation Permission Settings
On the sheet summary
Within your Personal Settings
Within the column properties for a contact list column -
ANSWER-Within the column properties for a contact list
column
How is tagging a shared collaborator, in a comment via an
@mention, an effective means of collaboration?
It shares that collaborator a published view of the sheet so they
can view the comment
It adds the @mentioned individual to your My Smartsheet
Contacts
,2|Page
It instantly sends the @mentioned individual a notification with
the comment
It begins keeping track of the @mentioned individual within
activity log - ANSWER-It instantly sends the @mentioned
individual a notification with the comment
A _________ is helpful when you need to share a number of
items with the same group of people. - ANSWER-Workspace
Auto-fill is automatically applied by Smartsheet within every
sheet. Which two of the following functions does auto-fill
perform?
Apply formulas and adjust cell references to adjacent rows
Continue patterns of formatting
Copy manual update requests to generate recurring updates
Generate a numeric value based on conditional formatting rules
- ANSWER-Apply formulas and adjust cell references to
adjacent rows
Continue patterns of formatting
Which column type would be best for visually representing the
status of a row item?
,3|Page
Emoji column
Symbols column
Text/Number column
Drop-down List column - ANSWER-Symbols column
When entering formulas in Smartsheet, cell references use the
syntax of column name and row number. What symbols must be
placed around a column name when it includes a space, special
characters, or numbers?
{ } Curly brackets
[ ] Square brackets
( ) Parentheses
< > Angle brackets - ANSWER-[ ] Square brackets
Scenario: You have a handful of tasks that are falling behind
schedule and you want to quickly view which items are marked
"Red" in your project status column.
Question: To identify this information WITHOUT having to
leave your sheet, you should:
Create a filter
Send an Update Request to your collaborators
Turn on Highlight Changes
, 4|Page
Write a formula - ANSWER-Create a filter
How is embedding a form on a dashboard via the web content
widget effective?
It allows an individual to complete a form submission without
leaving the dashboard
Users no longer need to be shared to the form to complete a
form submission
Using an interaction setting, you can provide instant access to
the underlying sheet
It automatically captures who completed a form submission in
the dashboard's activity log - ANSWER-It allows an individual
to complete a form submission without leaving the dashboard
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?
Highlight changes
Conditional formatting
Format painter
Alerts - ANSWER-Conditional formatting
Smartsheet Certification Exam Version 1, Smartsheet
Product Certification V1, Smartsheet Test Bank,
Smartsheet Questions and Answers, Smartsheet
Version 1 Exam, Smartsheet Study Guide, Smartsheet
Certification Prep
To assign a task to multiple contacts within a single cell, you
must enable multiple contacts. In what location can this
functionality be enabled?
In the Automation Permission Settings
On the sheet summary
Within your Personal Settings
Within the column properties for a contact list column -
ANSWER-Within the column properties for a contact list
column
How is tagging a shared collaborator, in a comment via an
@mention, an effective means of collaboration?
It shares that collaborator a published view of the sheet so they
can view the comment
It adds the @mentioned individual to your My Smartsheet
Contacts
,2|Page
It instantly sends the @mentioned individual a notification with
the comment
It begins keeping track of the @mentioned individual within
activity log - ANSWER-It instantly sends the @mentioned
individual a notification with the comment
A _________ is helpful when you need to share a number of
items with the same group of people. - ANSWER-Workspace
Auto-fill is automatically applied by Smartsheet within every
sheet. Which two of the following functions does auto-fill
perform?
Apply formulas and adjust cell references to adjacent rows
Continue patterns of formatting
Copy manual update requests to generate recurring updates
Generate a numeric value based on conditional formatting rules
- ANSWER-Apply formulas and adjust cell references to
adjacent rows
Continue patterns of formatting
Which column type would be best for visually representing the
status of a row item?
,3|Page
Emoji column
Symbols column
Text/Number column
Drop-down List column - ANSWER-Symbols column
When entering formulas in Smartsheet, cell references use the
syntax of column name and row number. What symbols must be
placed around a column name when it includes a space, special
characters, or numbers?
{ } Curly brackets
[ ] Square brackets
( ) Parentheses
< > Angle brackets - ANSWER-[ ] Square brackets
Scenario: You have a handful of tasks that are falling behind
schedule and you want to quickly view which items are marked
"Red" in your project status column.
Question: To identify this information WITHOUT having to
leave your sheet, you should:
Create a filter
Send an Update Request to your collaborators
Turn on Highlight Changes
, 4|Page
Write a formula - ANSWER-Create a filter
How is embedding a form on a dashboard via the web content
widget effective?
It allows an individual to complete a form submission without
leaving the dashboard
Users no longer need to be shared to the form to complete a
form submission
Using an interaction setting, you can provide instant access to
the underlying sheet
It automatically captures who completed a form submission in
the dashboard's activity log - ANSWER-It allows an individual
to complete a form submission without leaving the dashboard
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?
Highlight changes
Conditional formatting
Format painter
Alerts - ANSWER-Conditional formatting
