Smartsheet Certification: Questions With Verified
Solutions
What can be added to a dashboard to help users understand the data on a
dashboard? Right Ans - Text labels
Which option would allow someone to view a report if they are not shared to
the underlying sheet(s)? Right Ans - Add the report to a dashboard by
using the Report Widget
Which file type cannot be uploaded using the image widget? Right Ans -
PDF
Which two views of a row report can be displayed on a dashboard using the
report widget? Right Ans - Grid, Gantt
What is the default label for the data in a metric widget? Right Ans -
Column name
Which dashboard widget type would be best to show a live updating budget
number of a project? Right Ans - Metric
How is embedding a form on a dashboard via the web content widget
effective? Right Ans - It allows an individual to complete a form submission
without leaving the dashboard
Which widget behavior will allow the user to open the underlying sheet or
report? Right Ans - Open the data source
What symbol notes the beginning of a formula? Right Ans - =
Which formula is the most scalable way to count the indented rows under
"Carl Jackson", knowing that you will be adding additional rows within this
hierarchy? Right Ans - =COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet.
What is the syntax to reference the "Budget Total" field in a formula? Right
Ans - [Budget Total]#
, When adding a cell link to a sheet, which can be the source of the data?
Right Ans - Cell(s) in a sheet
When viewing a sheet, you want to have certain rows grab your attention,
visually, if the task is at risk or past its due date. You can accomplish this by
using which feature? Right Ans - Conditional formatting
Which is used when writing a formula to automate checking a box, raising a
flag, or filling in of a star? Right Ans - 1
Which column type would be best for assigning tasks to individual team
members? Right Ans - Contact List column
What symbols must be placed around a column name in a formula if the name
includes a space, special characters, or numbers? Right Ans - [ ] Square
brackets
Which view must include two date columns in order to be displayed? Right
Ans - Gantt
What level of hierarchy should the CHILDREN() function should be placed on?
Right Ans - Parent row
Which column type would be best for visually representing the status of a row
item? Right Ans - Symbols column
Which is one of the three column types that are required to enable Card View?
Right Ans - Contact List column
Which function can be used in conjunction with another function such as
COUNT() to reference all the cells directly indented under a parent row?
Right Ans - CHILDREN()
When hierarchy is applied to a row, where will it be visible? Right Ans -
Primary column
Which column type would be best for tracking when a row was added to a
sheet? Right Ans - Created (Date) System column
Solutions
What can be added to a dashboard to help users understand the data on a
dashboard? Right Ans - Text labels
Which option would allow someone to view a report if they are not shared to
the underlying sheet(s)? Right Ans - Add the report to a dashboard by
using the Report Widget
Which file type cannot be uploaded using the image widget? Right Ans -
Which two views of a row report can be displayed on a dashboard using the
report widget? Right Ans - Grid, Gantt
What is the default label for the data in a metric widget? Right Ans -
Column name
Which dashboard widget type would be best to show a live updating budget
number of a project? Right Ans - Metric
How is embedding a form on a dashboard via the web content widget
effective? Right Ans - It allows an individual to complete a form submission
without leaving the dashboard
Which widget behavior will allow the user to open the underlying sheet or
report? Right Ans - Open the data source
What symbol notes the beginning of a formula? Right Ans - =
Which formula is the most scalable way to count the indented rows under
"Carl Jackson", knowing that you will be adding additional rows within this
hierarchy? Right Ans - =COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet.
What is the syntax to reference the "Budget Total" field in a formula? Right
Ans - [Budget Total]#
, When adding a cell link to a sheet, which can be the source of the data?
Right Ans - Cell(s) in a sheet
When viewing a sheet, you want to have certain rows grab your attention,
visually, if the task is at risk or past its due date. You can accomplish this by
using which feature? Right Ans - Conditional formatting
Which is used when writing a formula to automate checking a box, raising a
flag, or filling in of a star? Right Ans - 1
Which column type would be best for assigning tasks to individual team
members? Right Ans - Contact List column
What symbols must be placed around a column name in a formula if the name
includes a space, special characters, or numbers? Right Ans - [ ] Square
brackets
Which view must include two date columns in order to be displayed? Right
Ans - Gantt
What level of hierarchy should the CHILDREN() function should be placed on?
Right Ans - Parent row
Which column type would be best for visually representing the status of a row
item? Right Ans - Symbols column
Which is one of the three column types that are required to enable Card View?
Right Ans - Contact List column
Which function can be used in conjunction with another function such as
COUNT() to reference all the cells directly indented under a parent row?
Right Ans - CHILDREN()
When hierarchy is applied to a row, where will it be visible? Right Ans -
Primary column
Which column type would be best for tracking when a row was added to a
sheet? Right Ans - Created (Date) System column
