1|Page
Smartsheet Certification Exam Version 1 Detailed Complete
Questions And Answers A+ Graded ||Just Out!!!
What field type is not available in Sheet Summary?
Date
Text/Number
Contact List
Dropdown (Multi-Select) - ANSWER-Dropdown (Multi-Select)
Scenario: Juan is currently managing the development of a new
product. He has a team of four individuals with whom he
assigns various tasks. Juan wants to quickly see tasks assigned
to each person and reassign tasks as needed.
Question: Which one of the options below would be the most
efficient way for Juan to accomplish this?
Juan needs to create and use a filter for each assignee and then
return to the sheet to reassign tasks.
Juan needs to utilize Card View to view tasks by the "assigned
to" contact column. He could then reassign tasks accordingly.
Juan needs to build a report for each person on his team. From
each of the reports, Juan would reassign tasks.
Juan needs to publish the sheet to his team and allow them to
email ideas on how the tasks should be reassigned. - ANSWER-
,2|Page
Juan needs to utilize Card View to view tasks by the "assigned
to" contact column. He could then reassign tasks accordingly.
Select which one of the following formats is not applicable for
exporting a sheet in Smartsheet.
Trello
PDF
Google Sheet
Excel
MS Project (XML)
Gantt to image (PNG) - ANSWER-Trello
You want to know when new attachments are added to your
sheet without opening the sheet. Which of the following is the
best way to achieve this goal?
Create a conditional formatting rule to highlight rows with new
attachments
Audit Activity Log daily
Create an alert to notify you when an attachment is added or
changed
,3|Page
Instruct collaborators to @mention you in the comments after
an attachment has been uploaded - ANSWER-Create an alert to
notify you when an attachment is added or changed
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 - ANSWER-Excel
PDF
Scenario: You are using Smartsheet to plan, track, and manage a
project. In creating your sheet, you are assigning tasks to
collaborators. You need to make a decision on whether to use
several single Contact List columns or enable multiple contacts
to be assigned within a single cell.
Question: In which one of the following scenarios is it best to
use several Contact List columns?
When the individuals have different roles related to a task.
When you want to create a filter for each individual.
, 4|Page
When you want to pull a report from a sheet.
When some individuals are inside your team's account and
others are not. - ANSWER-When the individuals have different
roles related to a task.
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 - ANSWER-Send a weekly recurring Update
Request
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
Smartsheet Certification Exam Version 1 Detailed Complete
Questions And Answers A+ Graded ||Just Out!!!
What field type is not available in Sheet Summary?
Date
Text/Number
Contact List
Dropdown (Multi-Select) - ANSWER-Dropdown (Multi-Select)
Scenario: Juan is currently managing the development of a new
product. He has a team of four individuals with whom he
assigns various tasks. Juan wants to quickly see tasks assigned
to each person and reassign tasks as needed.
Question: Which one of the options below would be the most
efficient way for Juan to accomplish this?
Juan needs to create and use a filter for each assignee and then
return to the sheet to reassign tasks.
Juan needs to utilize Card View to view tasks by the "assigned
to" contact column. He could then reassign tasks accordingly.
Juan needs to build a report for each person on his team. From
each of the reports, Juan would reassign tasks.
Juan needs to publish the sheet to his team and allow them to
email ideas on how the tasks should be reassigned. - ANSWER-
,2|Page
Juan needs to utilize Card View to view tasks by the "assigned
to" contact column. He could then reassign tasks accordingly.
Select which one of the following formats is not applicable for
exporting a sheet in Smartsheet.
Trello
Google Sheet
Excel
MS Project (XML)
Gantt to image (PNG) - ANSWER-Trello
You want to know when new attachments are added to your
sheet without opening the sheet. Which of the following is the
best way to achieve this goal?
Create a conditional formatting rule to highlight rows with new
attachments
Audit Activity Log daily
Create an alert to notify you when an attachment is added or
changed
,3|Page
Instruct collaborators to @mention you in the comments after
an attachment has been uploaded - ANSWER-Create an alert to
notify you when an attachment is added or changed
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 - ANSWER-Excel
Scenario: You are using Smartsheet to plan, track, and manage a
project. In creating your sheet, you are assigning tasks to
collaborators. You need to make a decision on whether to use
several single Contact List columns or enable multiple contacts
to be assigned within a single cell.
Question: In which one of the following scenarios is it best to
use several Contact List columns?
When the individuals have different roles related to a task.
When you want to create a filter for each individual.
, 4|Page
When you want to pull a report from a sheet.
When some individuals are inside your team's account and
others are not. - ANSWER-When the individuals have different
roles related to a task.
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 - ANSWER-Send a weekly recurring Update
Request
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
