Smartsheet Certification Exam 2024-2025 with
correct Question Verified Answers Graded A+
, 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 symbol notes the beginning of a formula?,=
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?,=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 or 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
Which is one of the three column types that are required to enable Card View?,Contact
List column
correct Question Verified Answers Graded A+
, 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 symbol notes the beginning of a formula?,=
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?,=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 or 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
Which is one of the three column types that are required to enable Card View?,Contact
List column
