Smartsheets Product Certification Part 1 Quiz
Study online at https://quizlet.com/_cvma4q
A row report can be displayed on a dashboard using the report
widget in which two of the following views?
Gantt Gantt
Calendar Card
Grid
Card
What Forms feature lets you reveal specific fields in a form based
on the answers to other questions?
Form Elements
Conditional Logic
Conditional Logic
Fields
Settings
To quickly identify and review the changes that have been made
to a sheet, use
Symbols column type
Highlight changes
Highlight changes
Conditional formatting
Format painter
When writing a formula, what symbol do you type to make either
a column or row reference absolute?
( ) Parentheses
$ Dollar sign
$ Dollar sign
# Pound sign
[ ] Square brackets
Which column type would be best for assigning tasks to individual
team members?
Contact List column
Contact List column
Created by System column
Text/Number column
Dropdown List
Scenario: You want to surface a count of at-risk tasks on a dash-
board. You determine one option for doing so would be to use a
drop-down column to mark a task at-risk.
Question: Which one of the following column types can also be
utilized to mark at-risk items that could be counted and displayed
Symbol Column
on a dashboard?
System Generated Column
Duration Column
Date Column
Symbol Column
Indenting rows will add hierarchy and create relationships be-
tween rows. The hierarchy is applied to the entire row, but will only
be visible in what part of the sheet?
Leftmost column in grid view Primary column
System column
Primary column
Row action indicators column
Which of the following views must include two date columns in
order to be displayed?
Calendar
Gantt Gantt
Grid
Card
Which one of the following Automation Permissions settings only
allows the users that are shared to a sheet to receive notifications
and requests from the sheet? Restricted
Limited
Unrestricted
, Smartsheets Product Certification Part 1 Quiz
Study online at https://quizlet.com/_cvma4q
Restricted
Unlimited
When adding a cell link to a sheet, which of the following can be
the source of the data?
Column names
Cell(s) in a sheet
Metric widget on a dashboard
Cell(s) in a sheet
Cell(s) in a report
In order to enable Card View, your sheet must have at least one
of three specific column types. Two of those columns types are
Dropdown List and Symbol. What is the third column type?
System Generated column Contact List column
Text/Number column
Contact List column
Date column
Which feature allows licensed collaborators [with at least Editor
permissions] to audit and export changes made to the sheet?
Conditional formatting
Activity log
Activity log
Highlight changes
View cell history
Based on the settings shown above, what permission level would
Don Miller have on the sheet?
Owner
Editor
Editor
Admin
Viewer
Scenario: Valentino created an alert to notify a contact in the
"assigned to" column if their task is past due and incomplete.
Valentino realized that one of his external contractors did not
receive the notification when this occurred.
Question: What is a likely reason an external collaborator does not
receive an automated notification?
The user must first be in your personal My Smartsheet Contacts
The Automation Permissions is not set to unrestricted so external
list in order to receive the notification
collaborators would not receive the notification
The Automation Permissions is not set to unrestricted so external
collaborators would not receive the notification
Valentino needed to create an approval request rather than an
alert
Alerts can only be sent to people in your account. You must send
a request, to your System Administrator, that the collaborator be
added to the account contact list
Scenario: Joy is the director of a sales team that manages its
pipeline in Smartsheet. Every time an opportunity status is marked
as "Closed Lost", reps should provide detail in a column called
"Reason Won/Lost".
Question: What is an automated way for Joy to ask reps to fill out
the "Reason Won/Lost" column if they do not initially do so?
Set up a workflow that sends an automated Update Request when Set up a workflow that sends an automated Update Request when
the opportunity status changes to "Closed Lost" and the "Reason
the opportunity status changes to "Closed Lost" and the "Reason
Won/Lost" column is blank
Won/Lost" column is blank
Create a Conditional Formatting rule that sends a request when
a task is marked as "Closed Lost"
Automate the workflow via a formula
Set up an automated Approval Request any time the "Reason
Won/Lost" column is left blank
Which of the following is used when writing a formula to automate
the checking of a box, raising a flag, or filling in of a star?
1
1
100%
Study online at https://quizlet.com/_cvma4q
A row report can be displayed on a dashboard using the report
widget in which two of the following views?
Gantt Gantt
Calendar Card
Grid
Card
What Forms feature lets you reveal specific fields in a form based
on the answers to other questions?
Form Elements
Conditional Logic
Conditional Logic
Fields
Settings
To quickly identify and review the changes that have been made
to a sheet, use
Symbols column type
Highlight changes
Highlight changes
Conditional formatting
Format painter
When writing a formula, what symbol do you type to make either
a column or row reference absolute?
( ) Parentheses
$ Dollar sign
$ Dollar sign
# Pound sign
[ ] Square brackets
Which column type would be best for assigning tasks to individual
team members?
Contact List column
Contact List column
Created by System column
Text/Number column
Dropdown List
Scenario: You want to surface a count of at-risk tasks on a dash-
board. You determine one option for doing so would be to use a
drop-down column to mark a task at-risk.
Question: Which one of the following column types can also be
utilized to mark at-risk items that could be counted and displayed
Symbol Column
on a dashboard?
System Generated Column
Duration Column
Date Column
Symbol Column
Indenting rows will add hierarchy and create relationships be-
tween rows. The hierarchy is applied to the entire row, but will only
be visible in what part of the sheet?
Leftmost column in grid view Primary column
System column
Primary column
Row action indicators column
Which of the following views must include two date columns in
order to be displayed?
Calendar
Gantt Gantt
Grid
Card
Which one of the following Automation Permissions settings only
allows the users that are shared to a sheet to receive notifications
and requests from the sheet? Restricted
Limited
Unrestricted
, Smartsheets Product Certification Part 1 Quiz
Study online at https://quizlet.com/_cvma4q
Restricted
Unlimited
When adding a cell link to a sheet, which of the following can be
the source of the data?
Column names
Cell(s) in a sheet
Metric widget on a dashboard
Cell(s) in a sheet
Cell(s) in a report
In order to enable Card View, your sheet must have at least one
of three specific column types. Two of those columns types are
Dropdown List and Symbol. What is the third column type?
System Generated column Contact List column
Text/Number column
Contact List column
Date column
Which feature allows licensed collaborators [with at least Editor
permissions] to audit and export changes made to the sheet?
Conditional formatting
Activity log
Activity log
Highlight changes
View cell history
Based on the settings shown above, what permission level would
Don Miller have on the sheet?
Owner
Editor
Editor
Admin
Viewer
Scenario: Valentino created an alert to notify a contact in the
"assigned to" column if their task is past due and incomplete.
Valentino realized that one of his external contractors did not
receive the notification when this occurred.
Question: What is a likely reason an external collaborator does not
receive an automated notification?
The user must first be in your personal My Smartsheet Contacts
The Automation Permissions is not set to unrestricted so external
list in order to receive the notification
collaborators would not receive the notification
The Automation Permissions is not set to unrestricted so external
collaborators would not receive the notification
Valentino needed to create an approval request rather than an
alert
Alerts can only be sent to people in your account. You must send
a request, to your System Administrator, that the collaborator be
added to the account contact list
Scenario: Joy is the director of a sales team that manages its
pipeline in Smartsheet. Every time an opportunity status is marked
as "Closed Lost", reps should provide detail in a column called
"Reason Won/Lost".
Question: What is an automated way for Joy to ask reps to fill out
the "Reason Won/Lost" column if they do not initially do so?
Set up a workflow that sends an automated Update Request when Set up a workflow that sends an automated Update Request when
the opportunity status changes to "Closed Lost" and the "Reason
the opportunity status changes to "Closed Lost" and the "Reason
Won/Lost" column is blank
Won/Lost" column is blank
Create a Conditional Formatting rule that sends a request when
a task is marked as "Closed Lost"
Automate the workflow via a formula
Set up an automated Approval Request any time the "Reason
Won/Lost" column is left blank
Which of the following is used when writing a formula to automate
the checking of a box, raising a flag, or filling in of a star?
1
1
100%
