Smartsheet Certification
Study online at
https://quizlet.com/_7tryt5
1.It instantly sends the @mentioned individual an alert with the comment.:
- 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
2.Create a filter: 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
3.Samuel wants to be sent an email five days before the start of each task
so he can check in with key collaborators: 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 com- plete
4.Continue patterns of formatting
Apply formulas and adjust cell references to adjacent rows: Auto-fill is
automat- ically applied by Smartsheet within every sheet. Which two of
the following functions does auto-fill perform?
, Smartsheet Certification
Study online at
Copy https://quizlet.com/_7tryt5
manual update requeststo 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
, Smartsheet Certification
Study online at
https://quizlet.com/_7tryt5
5.Web Content: The widget uses a URL or embed code to
surface interactive content on a dashboard.
Title
Report
Image
Web Content
6.Text/Number column: 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
7.Highlight changes: Changes in cell formatting can be used to capture
the atten- tion of a user. Which of the following features allows
collaborators to see updates since they last viewed the sheet?
Conditional
formatting Format
painter Symbol
column type
Highlight changes
8.File name
Date
attached
Name of the individual who attached the file: What information is tracked in
the Attachments Summary? (select the three that apply)
File name
Date
attached
Name of the individual who attached
the file Number of downloads
9.[ ] Square brackets: When entering formulas in Smartsheet, cell
references use the syntax of column name and row number. What
Study online at
https://quizlet.com/_7tryt5
1.It instantly sends the @mentioned individual an alert with the comment.:
- 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
2.Create a filter: 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
3.Samuel wants to be sent an email five days before the start of each task
so he can check in with key collaborators: 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 com- plete
4.Continue patterns of formatting
Apply formulas and adjust cell references to adjacent rows: Auto-fill is
automat- ically applied by Smartsheet within every sheet. Which two of
the following functions does auto-fill perform?
, Smartsheet Certification
Study online at
Copy https://quizlet.com/_7tryt5
manual update requeststo 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
, Smartsheet Certification
Study online at
https://quizlet.com/_7tryt5
5.Web Content: The widget uses a URL or embed code to
surface interactive content on a dashboard.
Title
Report
Image
Web Content
6.Text/Number column: 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
7.Highlight changes: Changes in cell formatting can be used to capture
the atten- tion of a user. Which of the following features allows
collaborators to see updates since they last viewed the sheet?
Conditional
formatting Format
painter Symbol
column type
Highlight changes
8.File name
Date
attached
Name of the individual who attached the file: What information is tracked in
the Attachments Summary? (select the three that apply)
File name
Date
attached
Name of the individual who attached
the file Number of downloads
9.[ ] Square brackets: When entering formulas in Smartsheet, cell
references use the syntax of column name and row number. What
