SMARTSHEET CORE PRODUCT CERTIFICATION EXAM
NEWEST 2024 COMPLETE QUESTIONS AND CORRECT
SOLUTIONS
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
Changes in cell formatting can be used to capture the attention of a user. Which of the following features
allows collaborators to see updates since they last viewed the sheet?
NEWEST 2024 COMPLETE QUESTIONS AND CORRECT
SOLUTIONS
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
Changes in cell formatting can be used to capture the attention of a user. Which of the following features
allows collaborators to see updates since they last viewed the sheet?
