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
... [Show More] 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
Which three of the following file types can be uploaded
using the image widget?
PDF
PNG
GIF
JPEG - ...ANSWER...PNG, GIF, JPEG
How can you add more fields to your report beyond what
fields are used as criteria?
From the File menu select Add More Columns
In the Report Builder, click the Columns button and select
additional columns
Add a column to a source sheet. This new column will
automatically be displayed in the report.
In the toolbar, click the Report Tool and select additional
criteria - ...ANSWER...In the Report Builder, click the
Columns button and select additional columns
Cell linking is done at which of the following levels?
Row
Column
Sheet
Cell - ...ANSWER...Cell
Forms can be used to collect information from individuals
inside or outside your organization. Which two of the
following use cases could a form support?
Survey responses
Marketing requests
Update the status of a task
Resource hub - ...ANSWER...Survey responses and
Marketing requests
The Notification Center: (select the two options that apply)
Displays a red icon when new notifications arrive
Allows a user to create new alerts
Allows a user to view and fulfill update requests
Allows a user to forward a notification to a different user -
...ANSWER...Displays a red icon when new notifications
arrive and alloWs a user to view and fulfill update requests
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 [Show Less]