Smartsheet Certification EXAM ACCURATE
TESTED VERSIONS OF THE EXAM FROM
2023TO 2024 | ACCURATE AND VERIFIED
ANSWERS | NEXT GEN FORMAT |
GUARANTEED PASS WITH 100+ QUESTIONS
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
- CORRECT ANS-[ ] Square brackets
When adding a new collaborator to a sheet or workspace, what should be customized to help
the new collaborator understand why they are being added and how they should use the
information?
Collaborators
Permissions
Personal message
Default View
,- CORRECT ANS-Personal Message
Which view must include two date columns in order to be displayed?
Card
Gantt
Calendar
Grid
- CORRECT ANS-Gantt
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 multiple single
contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple contact
list columns?
When you want to create a filter for each individual
When some individuals are inside your team's account and others are not
When you want to pull a report from a sheet
When the individuals have different roles related to a task
- CORRECT ANS-When the individuals have different roles related to a task
Daenerys has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Daenerys' sheet?
Editor- can't share
Viewer
, Admin
Editor- can share
- CORRECT ANS-Admin
Which function leverages sheet hierarchy to reference the range of rows that are indented
below another row?
ANCESTORS()
CHILDREN()
PARENT()
INDEX()
- CORRECT ANS-Children()
John is currently managing the development of a new product. He has a team of four
individuals with whom he assigns various tasks. John wants to quickly see tasks assigned to
each person and reassign tasks as needed. Which of the options below would be the most
efficient way for John to accomplish this?
John needs to create and use a filter for each assignee and then return to the sheet to reassign
tasks.
John needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
John needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
John needs to build a report for each person on his team. From each of the reports, Juan would
reassign tasks.`
- CORRECT ANS-John needs to utilize card view to view by the assigned to contact column. He
could then view and reassign accordingly.
You can share a collaborator to which two of the following?
TESTED VERSIONS OF THE EXAM FROM
2023TO 2024 | ACCURATE AND VERIFIED
ANSWERS | NEXT GEN FORMAT |
GUARANTEED PASS WITH 100+ QUESTIONS
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
- CORRECT ANS-[ ] Square brackets
When adding a new collaborator to a sheet or workspace, what should be customized to help
the new collaborator understand why they are being added and how they should use the
information?
Collaborators
Permissions
Personal message
Default View
,- CORRECT ANS-Personal Message
Which view must include two date columns in order to be displayed?
Card
Gantt
Calendar
Grid
- CORRECT ANS-Gantt
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 multiple single
contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple contact
list columns?
When you want to create a filter for each individual
When some individuals are inside your team's account and others are not
When you want to pull a report from a sheet
When the individuals have different roles related to a task
- CORRECT ANS-When the individuals have different roles related to a task
Daenerys has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Daenerys' sheet?
Editor- can't share
Viewer
, Admin
Editor- can share
- CORRECT ANS-Admin
Which function leverages sheet hierarchy to reference the range of rows that are indented
below another row?
ANCESTORS()
CHILDREN()
PARENT()
INDEX()
- CORRECT ANS-Children()
John is currently managing the development of a new product. He has a team of four
individuals with whom he assigns various tasks. John wants to quickly see tasks assigned to
each person and reassign tasks as needed. Which of the options below would be the most
efficient way for John to accomplish this?
John needs to create and use a filter for each assignee and then return to the sheet to reassign
tasks.
John needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
John needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
John needs to build a report for each person on his team. From each of the reports, Juan would
reassign tasks.`
- CORRECT ANS-John needs to utilize card view to view by the assigned to contact column. He
could then view and reassign accordingly.
You can share a collaborator to which two of the following?
