Smartsheet Certification Test Latest Updated 2024
Which file type cannot be uploaded using the image widget PDF
Which two views of a row report can be displayed on a dashboard using the report widget?:
Grid, Gantt
What is the default label for the data in a metric widget?: Column name
Which dashboard widget type would be best to show a live updating budget number of a project?: Metric
How is embedding a form on a dashboard via the web content widget effective?
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?: Open the data
source
What can be added to a dashboard to help users understand the data on a dashboard?: Text labels
Which option would allow someone to view a report if they are not shared to the underlying sheet(s)?:
Add the report to a dashboard by using the Report Widget
What symbol notes the beginning of a formula?: =
Which formula is the most scalable way to count the indented rows under "Carl Jackson", knowing that
1/5
, you will be adding additional rows within this hierarchy =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?: [Budget Total]#
When adding a cell link to a sheet, which can be the source of the data?: -
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 o
past its due date. You can accomplish this by using which feature?: Conditional formatting
Which is used when writing a formula to automate checking a box, raising a flag, or filling in of a star?: 1
Which column type would be best for assigning tasks to individual team members?: 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?: [ ] Square brackets
Which view must include two date columns in order to be displayed?: Gantt
What level of hierarchy should the CHILDREN() function should be placed on?: Parent row
Which column type would be best for visually representing the status of a row item?: Symbols column
2/5
Which file type cannot be uploaded using the image widget PDF
Which two views of a row report can be displayed on a dashboard using the report widget?:
Grid, Gantt
What is the default label for the data in a metric widget?: Column name
Which dashboard widget type would be best to show a live updating budget number of a project?: Metric
How is embedding a form on a dashboard via the web content widget effective?
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?: Open the data
source
What can be added to a dashboard to help users understand the data on a dashboard?: Text labels
Which option would allow someone to view a report if they are not shared to the underlying sheet(s)?:
Add the report to a dashboard by using the Report Widget
What symbol notes the beginning of a formula?: =
Which formula is the most scalable way to count the indented rows under "Carl Jackson", knowing that
1/5
, you will be adding additional rows within this hierarchy =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?: [Budget Total]#
When adding a cell link to a sheet, which can be the source of the data?: -
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 o
past its due date. You can accomplish this by using which feature?: Conditional formatting
Which is used when writing a formula to automate checking a box, raising a flag, or filling in of a star?: 1
Which column type would be best for assigning tasks to individual team members?: 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?: [ ] Square brackets
Which view must include two date columns in order to be displayed?: Gantt
What level of hierarchy should the CHILDREN() function should be placed on?: Parent row
Which column type would be best for visually representing the status of a row item?: Symbols column
2/5
