Smartsheet Core Product Certification Exam Latest Updated 2024
A snapshot of a sheet or report can be shared via email using the "Send as Attachment..."
action. The sheet can be sent once or on a recurring basis. Select the two file formats the
attachment can be sent as.
Excel PDF CSV
PNG - ...ANSWER...Excel and PDF
When viewing a sheet, you want to have certain rows grab your attention, if the task is at
risk or past its due date. You can accomplish this by using which feature?
Highlight changes Conditional formatting Alerts
Format painter - ...ANSWER...Conditional formatting
,The "Send..." action, available from the row menu, allows you to provide a view-only version
of one or more rows to anyone you specify. Which two of the following options can be
customized?
File format of the rows (PDF or Excel) Custom message to recipient
Delivery recurrence (once, every hour, every day, etc.) Columns included -
...ANSWER...Custom message to recipient and columns included
Which feature allows licensed collaborators [with at least Editor permissions] to audit
changes made to the sheet?
Conditional formatting Activity log
View cell history
Highlight changes - ...ANSWER...Activity Log
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 - ...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 -
...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 - ...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 - ...ANSWER...Continue patterns of formatting Apply
formulas and adjust cell references to adjacent rows
Which column type would be best for visually representing (via color) the status of a row
item? This could also be automatically changed using a formula.
Symbol column Dropdown List column Text/Number column
System Generated column - ...ANSWER...Symbol column
Which three of the following items can be viewed without a Smartsheet account?
, Form
Published dashboard
Report in a workspace shared to you
Update request - ...ANSWER...Form, Published dashboard, and Update request
A snapshot of a sheet or report can be shared via email using the "Send as Attachment..."
action. The sheet can be sent once or on a recurring basis. Select the two file formats the
attachment can be sent as.
Excel PDF CSV
PNG - ...ANSWER...Excel and PDF
When viewing a sheet, you want to have certain rows grab your attention, if the task is at
risk or past its due date. You can accomplish this by using which feature?
Highlight changes Conditional formatting Alerts
Format painter - ...ANSWER...Conditional formatting
,The "Send..." action, available from the row menu, allows you to provide a view-only version
of one or more rows to anyone you specify. Which two of the following options can be
customized?
File format of the rows (PDF or Excel) Custom message to recipient
Delivery recurrence (once, every hour, every day, etc.) Columns included -
...ANSWER...Custom message to recipient and columns included
Which feature allows licensed collaborators [with at least Editor permissions] to audit
changes made to the sheet?
Conditional formatting Activity log
View cell history
Highlight changes - ...ANSWER...Activity Log
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 - ...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 -
...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 - ...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 - ...ANSWER...Continue patterns of formatting Apply
formulas and adjust cell references to adjacent rows
Which column type would be best for visually representing (via color) the status of a row
item? This could also be automatically changed using a formula.
Symbol column Dropdown List column Text/Number column
System Generated column - ...ANSWER...Symbol column
Which three of the following items can be viewed without a Smartsheet account?
, Form
Published dashboard
Report in a workspace shared to you
Update request - ...ANSWER...Form, Published dashboard, and Update request
