Smartsheet Certification Exam (Latest 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Grade A

Smartsheet Certification Exam (Latest 2023/

2024 Update) Questions and Verified

Answers| 100% Correct| Grade A

Q: When adding a cell link to a sheet, which of the following can be the source of the data?

Column names

Metric widget on a dashboard

Cell(s) in a sheet

Cell(s) in a report

Answer:

Cell(s) in a sheet

Q: In order to enable Card View, your sheet must have at least one of three specific column

types. Two of those columns types are Dropdown List and Symbol. What is the third column

type?

System Generated column

Text/Number column

Contact List column

Date column

Answer:

Contact List column

Q: Which feature allows licensed collaborators [with at least Editor permissions] to audit and

export changes made to the sheet?

Conditional formatting

Activity log

Highlight changes

View cell history

Answer:

Activity log

Q: Based on the settings shown above, what permission level would Don Miller have on the

sheet?

Owner

Editor

Admin

Viewer

Answer:

Editor

Q: Scenario: Valentino created an alert to notify a contact in the "assigned to" column if their

task is past due and incomplete. Valentino realized that one of his external contractors did not

receive the notification when this occurred.

Question: What is a likely reason an external collaborator does not receive an automated

notification?

The user must first be in your personal My Smartsheet Contacts list in order to receive the

notification

The Automation Permissions is not set to unrestricted so external collaborators would not receive

the notification

Valentino needed to create an approval request rather than an alert

Alerts can only be sent to people in your account. You must send a request, to your System

Administrator, that the collaborator be added to the account contact list

Answer:

The Automation Permissions is not set to unrestricted so external collaborators would not receive

the notification

Q: Scenario: Joy is the director of a sales team that manages its pipeline in Smartsheet. Every

time an opportunity status is marked as "Closed Lost", reps should provide detail in a column

called "Reason Won/Lost".

Question: What is an automated way for Joy to ask reps to fill out the "Reason Won/Lost"

column if they do not initially do so?

Set up a workflow that sends an automated Update Request when the opportunity status changes

to "Closed Lost" and the "Reason Won/Lost" column is blank

Create a Conditional Formatting rule that sends a request when a task is marked as "Closed Lost"

Automate the workflow via a formula

Set up an automated Approval Request any time the "Reason Won/Lost" column is left blank

Answer:

Set up a workflow that sends an automated Update Request when the opportunity status changes

to "Closed Lost" and the "Reason Won/Lost" column is blank

Q: Which of the following is used when writing a formula to automate the checking of a box,

raising a flag, or filling in of a star?

1

100%

Return

Yes

Answer:

1

Q: When you create a new form for a sheet in Smartsheet, the form is automatically populated

with fields based on which sheet element?

Primary column

Drop-down list

Columns

Rows

Answer:

Columns

Q: The Notification Center: (select the two options that apply)

Allows a user to forward a notification to a different user

Displays a red icon when new notifications arrive

Allows a user to create new alerts

Allows a user to view and fulfill update requests

Answer:

Allows a user to view and fulfill update requests

Displays a red icon when new notifications arrive