Smartsheets Product Certification Part 1 Quiz
Latest Update 2024-2025 Actual Exam Questions
and 100% Verified Correct Answers Guaranteed
A+
A _________ is helpful when you need to share a number of items with the same group
of people. - CORRECT ANSWER: Workspace
A manager wants to automatically ask a team member to add status comments to a row
every week. What is the best way to achieve this?
Ask the team member to cell link their comments into the sheet. Set the update
frequency, for the cell link, to refresh weekly
Create a filter for each team member and send the filtered view on a weekly basis
Send a weekly recurring Update Request
Send the comments thread directly to team members, on a weekly basis - CORRECT
ANSWER: Send a weekly recurring Update Request
A row report can be displayed on a dashboard using the report widget in which two of
the following views?
Gantt
Calendar
Grid
Card - CORRECT ANSWER: Gantt
Card
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.
CSV
PNG
,Excel
PDF - CORRECT ANSWER: Excel
PDF
Alerts with date-based triggers help keep collaborators aware of key dates. Which of the
following is a possible use-case for establishing an alert with a date as the trigger?
You want to notify all collaborators when a task is over budget
You want to be sent an email five days before the start of each task so that you can
check in with key collaborators
You want to automatically let external vendors know when a task is not complete
You want to automatically inform your boss when the status of a task becomes at-risk -
CORRECT ANSWER: You want to be sent an email five days before the start of each
task so that you can check in with key collaborators
An update request provides one-time Editor access. What feature could be used to
allow information to be included in an update request, but restrict the recipient from
making changes?
Change sharing permissions
Lock column
Conditional formatting
Filters - CORRECT ANSWER: Lock column
As the owner of a sheet, you would like to provide an external collaborator the ability to
update their tasks regularly, but not have access to the underlying sheet. Which of the
below actions meets this requirement?
Send a row
Schedule a recurring update request
Share them to the sheet as a viewer
Publish a "Edit by anyone" link - CORRECT ANSWER: Schedule a recurring update
request
, As the owner of a sheet, you would like to provide an external collaborator the ability to
update their tasks regularly, but not have access to the underlying sheet. Which of the
below actions meets this requirement?
Share them to the sheet as a viewer
Schedule a recurring update request
Publish a "Edit by anyone" link
Send a row - CORRECT ANSWER: Schedule a recurring update request
Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the
following functions does auto-fill perform?
Apply formulas and adjust cell references to adjacent rows
Continue patterns of formatting
Copy manual update requests to generate recurring updates
Generate a numeric value based on conditional formatting rules - CORRECT ANSWER:
Apply formulas and adjust cell references to adjacent rows
Continue patterns of formatting
Based on the settings shown above, what permission level would Don Miller have on
the sheet?
Owner
Editor
Admin
Viewer - CORRECT ANSWER: Editor
Both sharing and publishing are features that can be used to give view only access to a
sheet. What is the difference between sharing a sheet as a viewer and sending a
published link?
There is no difference between viewing a published sheet and a shared sheet
Viewing a shared sheet grants access to see attachments and comments, published
sheets do not
Latest Update 2024-2025 Actual Exam Questions
and 100% Verified Correct Answers Guaranteed
A+
A _________ is helpful when you need to share a number of items with the same group
of people. - CORRECT ANSWER: Workspace
A manager wants to automatically ask a team member to add status comments to a row
every week. What is the best way to achieve this?
Ask the team member to cell link their comments into the sheet. Set the update
frequency, for the cell link, to refresh weekly
Create a filter for each team member and send the filtered view on a weekly basis
Send a weekly recurring Update Request
Send the comments thread directly to team members, on a weekly basis - CORRECT
ANSWER: Send a weekly recurring Update Request
A row report can be displayed on a dashboard using the report widget in which two of
the following views?
Gantt
Calendar
Grid
Card - CORRECT ANSWER: Gantt
Card
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.
CSV
PNG
,Excel
PDF - CORRECT ANSWER: Excel
Alerts with date-based triggers help keep collaborators aware of key dates. Which of the
following is a possible use-case for establishing an alert with a date as the trigger?
You want to notify all collaborators when a task is over budget
You want to be sent an email five days before the start of each task so that you can
check in with key collaborators
You want to automatically let external vendors know when a task is not complete
You want to automatically inform your boss when the status of a task becomes at-risk -
CORRECT ANSWER: You want to be sent an email five days before the start of each
task so that you can check in with key collaborators
An update request provides one-time Editor access. What feature could be used to
allow information to be included in an update request, but restrict the recipient from
making changes?
Change sharing permissions
Lock column
Conditional formatting
Filters - CORRECT ANSWER: Lock column
As the owner of a sheet, you would like to provide an external collaborator the ability to
update their tasks regularly, but not have access to the underlying sheet. Which of the
below actions meets this requirement?
Send a row
Schedule a recurring update request
Share them to the sheet as a viewer
Publish a "Edit by anyone" link - CORRECT ANSWER: Schedule a recurring update
request
, As the owner of a sheet, you would like to provide an external collaborator the ability to
update their tasks regularly, but not have access to the underlying sheet. Which of the
below actions meets this requirement?
Share them to the sheet as a viewer
Schedule a recurring update request
Publish a "Edit by anyone" link
Send a row - CORRECT ANSWER: Schedule a recurring update request
Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the
following functions does auto-fill perform?
Apply formulas and adjust cell references to adjacent rows
Continue patterns of formatting
Copy manual update requests to generate recurring updates
Generate a numeric value based on conditional formatting rules - CORRECT ANSWER:
Apply formulas and adjust cell references to adjacent rows
Continue patterns of formatting
Based on the settings shown above, what permission level would Don Miller have on
the sheet?
Owner
Editor
Admin
Viewer - CORRECT ANSWER: Editor
Both sharing and publishing are features that can be used to give view only access to a
sheet. What is the difference between sharing a sheet as a viewer and sending a
published link?
There is no difference between viewing a published sheet and a shared sheet
Viewing a shared sheet grants access to see attachments and comments, published
sheets do not
