SMARTSHEET CERTIFICATION EXAM
SCRIPT VERIFIED QUESTIONS AND
SOLUTIONS COMPLETE REVIEW MATERIAL
●● Which option would allow someone to view a report if they are not
shared to the underlying sheet(s)?
Answer: Add the report to a dashboard by using the Report Widget
●● Which file type cannot be uploaded using the image widget?
Answer: PDF
●● Which two views of a row report can be displayed on a dashboard
using the report widget?
Answer: Grid, Gantt
●● What is the default label for the data in a metric widget?
Answer: Column name
●● Which dashboard widget type would be best to show a live updating
budget number of a project?
Answer: Metric
, ●● How is embedding a form on a dashboard via the web content widget
effective?
Answer: 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?
Answer: Open the data source
●● What symbol notes the beginning of a formula?
Answer: =
●● 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?
Answer: =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?
Answer: [Budget Total]#
●● When adding a cell link to a sheet, which can be the source of the
data?
SCRIPT VERIFIED QUESTIONS AND
SOLUTIONS COMPLETE REVIEW MATERIAL
●● Which option would allow someone to view a report if they are not
shared to the underlying sheet(s)?
Answer: Add the report to a dashboard by using the Report Widget
●● Which file type cannot be uploaded using the image widget?
Answer: PDF
●● Which two views of a row report can be displayed on a dashboard
using the report widget?
Answer: Grid, Gantt
●● What is the default label for the data in a metric widget?
Answer: Column name
●● Which dashboard widget type would be best to show a live updating
budget number of a project?
Answer: Metric
, ●● How is embedding a form on a dashboard via the web content widget
effective?
Answer: 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?
Answer: Open the data source
●● What symbol notes the beginning of a formula?
Answer: =
●● 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?
Answer: =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?
Answer: [Budget Total]#
●● When adding a cell link to a sheet, which can be the source of the
data?
