SMARTSHEET CERTIFICATION EXAM
SCRIPT COMPREHENSIVE STUDY GUIDE
●● What Forms feature lets you reveal specific fields in a form based on
the answers to other questions?
Form Elements
Conditional Logic
Fields
Settings
Answer: Conditional Logic
●● To quickly identify and review the changes that have been made to a
sheet, use _________
Symbols column type
Highlight changes
Conditional formatting
Format painter
Answer: Highlight changes
●● When writing a formula, what symbol do you type to make either a
column or row reference absolute?
( ) Parentheses
,$ Dollar sign
# Pound sign
[ ] Square brackets
Answer: $ Dollar sign
●● Which column type would be best for assigning tasks to individual
team members?
Contact List column
Created by System column
Text/Number column
Dropdown List
Answer: Contact List column
●● Scenario: You want to surface a count of at-risk tasks on a
dashboard. 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 on a
dashboard?
System Generated Column
Duration Column
Date Column
Symbol Column
, Answer: Symbol Column
●● Indenting rows will add hierarchy and create relationships between
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
System column
Primary column
Row action indicators column
Answer: Primary column
●● Which of the following views must include two date columns in
order to be displayed?
Calendar
Gantt
Grid
Card
Answer: Gantt
●● 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?
Limited
SCRIPT COMPREHENSIVE STUDY GUIDE
●● What Forms feature lets you reveal specific fields in a form based on
the answers to other questions?
Form Elements
Conditional Logic
Fields
Settings
Answer: Conditional Logic
●● To quickly identify and review the changes that have been made to a
sheet, use _________
Symbols column type
Highlight changes
Conditional formatting
Format painter
Answer: Highlight changes
●● When writing a formula, what symbol do you type to make either a
column or row reference absolute?
( ) Parentheses
,$ Dollar sign
# Pound sign
[ ] Square brackets
Answer: $ Dollar sign
●● Which column type would be best for assigning tasks to individual
team members?
Contact List column
Created by System column
Text/Number column
Dropdown List
Answer: Contact List column
●● Scenario: You want to surface a count of at-risk tasks on a
dashboard. 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 on a
dashboard?
System Generated Column
Duration Column
Date Column
Symbol Column
, Answer: Symbol Column
●● Indenting rows will add hierarchy and create relationships between
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
System column
Primary column
Row action indicators column
Answer: Primary column
●● Which of the following views must include two date columns in
order to be displayed?
Calendar
Gantt
Grid
Card
Answer: Gantt
●● 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?
Limited
