Smartsheet Certification_ Complete Latest Questions/Answers.

Smartsheet Certification Exam

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 - 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 - 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 -

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 - Continue patterns of

formatting

Apply formulas and adjust cell references to adjacent rows

The ___________ widget uses a URL or embed code to surface interactive content on a

dashboard.

Title

Report

Image

Web Content - Web Content

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 - Text/Number column

Changes in cell formatting can be used to capture the attention 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 - Highlight changes

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 - File name

Date attached

Name of the individual who attached the file

When entering formulas in Smartsheet, cell references use the syntax of column name and

row number. What symbol must be placed around a column name when it includes a space,

special character, or number?

{ } Curly brackets

[ ] Square brackets

< > Angle brackets

( ) Parentheses - [ ] Square brackets

No comments found.
Login to post a comment
This item has not received any review yet.
Login to review this item
No Questions / Answers added yet.
Version latest
Included files pdf
Authors qwivy.com
Pages 10
Language English
Tags Smartsheet Certification_ Complete Latest Questions/Answers.
Comments 0
Sales 0
Recently viewed items

We use cookies to understand how you use our website and to improve your experience. This includes personalizing content and advertising. To learn more, please click Here. By continuing to use our website, you accept our use of cookies, Privacy policy and terms & conditions.

Processing