Smartsheet Certification UPDATED
ACTUAL Exam Questions and CORRECT
Answers
How is tagging a shared collaborator in a comment, via the use of @mention, an effective means
of collaboration?
It shares that collaborator a published view of the sheet so they can view the comment.
It instantly sends the @mentioned individual an alert with the comment.
It begins keeping track of the @mentioned individual within activity log.
It adds the @mentioned individual to your My Smartsheet Contacts - CORRECT
ANSWER - It instantly sends the @mentioned individual an alert with the comment.
I have a handful of tasks that are falling behind schedule and I want to quickly view which items
are marked "Red" in my project status column. To identify this information WITHOUT having
to leave the sheet, I should:
Turn on highlight changes
Write a formula
Create a filter
Send an update request to my collaborators - CORRECT ANSWER - Create a filter
Date based alerts help keep collaborators aware of key project dates. Date based alerts can be
triggered on a specific date or based off a date in any date column. Which of the following is a
possible use case for establishing a date based alert?
Samuel wants to automatically inform his boss when the status of a task becomes at-risk
Samuel wants to notify all collaborators when a task is over budget
Samuel wants to be sent an email five days before the start of each task so he can check in with
key collaborators
, Samuel wants to automatically let external vendors know when a task is not complete -
CORRECT ANSWER - Samuel wants to be sent an email five days before the start of
each task so he can check in with key collaborators
Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the following
functions does auto-fill perform?
Copy manual update requests to generate recurring updates
Continue patterns of formatting
Apply formulas and adjust cell references to adjacent rows
Generate a numeric value based on conditional formatting rules - CORRECT ANSWER -
Continue patterns of formatting
Apply formulas and adjust cell references to adjacent rows
The ___________ widget uses a URL or embed code to surface interactive content on a
dashboard.
Title
Report
Image
Web Content - CORRECT ANSWER - Web Content
In order to enable Card View, your sheet must have a least one of three specific column types.
Two of those columns are dropdown list and symbol. What is the third column type?
Date column
Text/Number column
System Generated column
Contact List column - CORRECT ANSWER - Text/Number column
ACTUAL Exam Questions and CORRECT
Answers
How is tagging a shared collaborator in a comment, via the use of @mention, an effective means
of collaboration?
It shares that collaborator a published view of the sheet so they can view the comment.
It instantly sends the @mentioned individual an alert with the comment.
It begins keeping track of the @mentioned individual within activity log.
It adds the @mentioned individual to your My Smartsheet Contacts - CORRECT
ANSWER - It instantly sends the @mentioned individual an alert with the comment.
I have a handful of tasks that are falling behind schedule and I want to quickly view which items
are marked "Red" in my project status column. To identify this information WITHOUT having
to leave the sheet, I should:
Turn on highlight changes
Write a formula
Create a filter
Send an update request to my collaborators - CORRECT ANSWER - Create a filter
Date based alerts help keep collaborators aware of key project dates. Date based alerts can be
triggered on a specific date or based off a date in any date column. Which of the following is a
possible use case for establishing a date based alert?
Samuel wants to automatically inform his boss when the status of a task becomes at-risk
Samuel wants to notify all collaborators when a task is over budget
Samuel wants to be sent an email five days before the start of each task so he can check in with
key collaborators
, Samuel wants to automatically let external vendors know when a task is not complete -
CORRECT ANSWER - Samuel wants to be sent an email five days before the start of
each task so he can check in with key collaborators
Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the following
functions does auto-fill perform?
Copy manual update requests to generate recurring updates
Continue patterns of formatting
Apply formulas and adjust cell references to adjacent rows
Generate a numeric value based on conditional formatting rules - CORRECT ANSWER -
Continue patterns of formatting
Apply formulas and adjust cell references to adjacent rows
The ___________ widget uses a URL or embed code to surface interactive content on a
dashboard.
Title
Report
Image
Web Content - CORRECT ANSWER - Web Content
In order to enable Card View, your sheet must have a least one of three specific column types.
Two of those columns are dropdown list and symbol. What is the third column type?
Date column
Text/Number column
System Generated column
Contact List column - CORRECT ANSWER - Text/Number column
