Smartsheet Core Product Certification |\ |\ |\ |\
questions with answers |\ |\
Xiao is trying to create a metrics sheet that will calculate
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the health of all the current ongoing campaigns in her
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
marketing portfolio. She has a Health column in each |\ |\ |\ |\ |\ |\ |\ |\ |\
campaign's sheet and is using the Symbol column type to |\ |\ |\ |\ |\ |\ |\ |\ |\
indicate red, yellow, or green for the health status. Which
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of the following formulas should Xiao use in her metrics
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
sheet to calculate how many campaigns have a health
|\ |\ |\ |\ |\ |\ |\ |\ |\
status of red? |\ |\
=COUNTIF({Portfolio Summary Rollup Sheet Range 1}, |\ |\ |\ |\ |\
"Red") is correct. This formula uses the COUNTIF function
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
to count the number of campaigns with a health status of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
red in a particular portfolio. Formulas that are looking at
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the Symbol column type, such as the Health column in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
this scenario, require each symbol's color to be
|\ |\ |\ |\ |\ |\ |\ |\
capitalized.
Danielle would like to have her entire department review
|\ |\ |\ |\ |\ |\ |\ |\ |\
a report weekly. Additionally, even though there are a few
|\ |\ |\ |\ |\ |\ |\ |\ |\
associates who don't have access to Smartsheet,
|\ |\ |\ |\ |\ |\ |\ |\
Danielle wants to ensure that everyone has access to an
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
up-to-date version of the report at any time. What is the |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
recommended action for Danielle to take? |\ |\ |\ |\ |\
,Send the report as an attachment as a weekly recurrence
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and include the published link in the body of the message
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
is correct. Reports can be sent to any email address as an
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
attachment on a weekly basis without having to give
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
anyone access to the report itself. Publishing the report
|\ |\ |\ |\ |\ |\ |\ |\ |\
and including the link in the body of the weekly
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
notification allows anyone to access the up-to-date- |\ |\ |\ |\ |\ |\
version of the report at any time. |\ |\ |\ |\ |\ |\
Celina is looking to lock in a column value in the following
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
formula, so that she could apply the formula to any row
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and it would still reference the same column:
|\ |\ |\ |\ |\ |\ |\
=IF([%Complete]@row=1, "Green", "Yellow") |\ |\
What should Celina add to the formula?
|\ |\ |\ |\ |\ |\
=IF($[%Complete]@row=1, "Green", "Yellow") is correct. |\ |\ |\ |\ |\
The $ is an absolute reference. In this case, the absolute
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
reference should appear before the column %Complete, |\ |\ |\ |\ |\ |\ |\
which will tell the formula to always reference the
|\ |\ |\ |\ |\ |\ |\ |\ |\
%Complete column regardless of the cell the formula is |\ |\ |\ |\ |\ |\ |\ |\ |\
in.
Ken is building an event schedule. He would like everyone
|\ |\ |\ |\ |\ |\ |\ |\ |\
to simultaneously see the whole schedule at one time but
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
also allow each team member to focus on their own tasks
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
immediately.
|\
,Which is the most efficient way to accomplish this?
|\ |\ |\ |\ |\ |\ |\ |\
Create conditional formatting to assign a color to each
|\ |\ |\ |\ |\ |\ |\ |\ |\
team member is correct. If the sheet has an Assigned To
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
column that lists which team member has been assigned
|\ |\ |\ |\ |\ |\ |\ |\ |\
to each task, Ken can use conditional formatting to
|\ |\ |\ |\ |\ |\ |\ |\ |\
associate each teammate's name to a color. This way |\ |\ |\ |\ |\ |\ |\ |\ |\
each teammate can see the whole schedule while only
|\ |\ |\ |\ |\ |\ |\ |\ |\
focusing on their assigned color. |\ |\ |\ |\
Carson is creating a form to collect requests for IT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
equipment and software support from employees at their |\ |\ |\ |\ |\ |\ |\ |\
organization. The source sheet has the following columns: |\ |\ |\ |\ |\ |\ |\
Request Type, Equipment, Date Needed, Software, and
|\ |\ |\ |\ |\ |\ |\ |\
Issue. If an employee selects IT Equipment from the
|\ |\ |\ |\ |\ |\ |\ |\ |\
Request Type field, they need to submit answers for the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Equipment and Date Needed columns. If they select IT |\ |\ |\ |\ |\ |\ |\ |\ |\
Software Support from the Request Type field, they need
|\ |\ |\ |\ |\ |\ |\ |\ |\
to submit answers for the Software and Issue fields. What
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
is the recommended way for Carson to set up their form
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
to ensure they collect the responses they need?
|\ |\ |\ |\ |\ |\ |\
Add form logic to the Request Type field is correct. Carson
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
should add two rules to the logic for the Request Type
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
field:
, Mary is setting up a project schedule with predecessors
|\ |\ |\ |\ |\ |\ |\ |\ |\
and has created an Overdue column with a formula that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
calculates how many days a task is overdue. Now she |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
wants to visualize the severity of the delay, depending on
|\ |\ |\ |\ |\ |\ |\ |\ |\
how many days a task is overdue. What is the most
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
efficient way to accomplish this? |\ |\ |\ |\
Create conditional formatting rules that assign a color to
|\ |\ |\ |\ |\ |\ |\ |\ |\
a row based on how many days a task is overdue is
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
correct. Creating conditional formatting rules allows Mary
|\ |\ |\ |\ |\ |\ |\
to assign a different color for different ranges of days that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
each task is overdue.
|\ |\ |\ |\
Benjy wants his associates to be able to update the status
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of their tasks on a report he has built. He also wants this
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
updated information to appear on the underlying sheets. |\ |\ |\ |\ |\ |\ |\ |\
What does Benjy need to do to ensure his associates can
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
update both the report and the underlying sheets? |\ |\ |\ |\ |\ |\ |\
Grant all associates Editor or higher permissions on the
|\ |\ |\ |\ |\ |\ |\ |\ |\
report and the underlying sheets is correct. Users must
|\ |\ |\ |\ |\ |\ |\ |\ |\
have at least Editor permissions on both the report and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the source sheet(s) to edit info in a report, which will then
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
populate back to the source sheets.
|\ |\ |\ |\ |\ |\
Juan is looking to automate the symbols that are
|\ |\ |\ |\ |\ |\ |\ |\ |\
produced in his Health column. He applies a nested IF |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
questions with answers |\ |\
Xiao is trying to create a metrics sheet that will calculate
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the health of all the current ongoing campaigns in her
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
marketing portfolio. She has a Health column in each |\ |\ |\ |\ |\ |\ |\ |\ |\
campaign's sheet and is using the Symbol column type to |\ |\ |\ |\ |\ |\ |\ |\ |\
indicate red, yellow, or green for the health status. Which
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of the following formulas should Xiao use in her metrics
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
sheet to calculate how many campaigns have a health
|\ |\ |\ |\ |\ |\ |\ |\ |\
status of red? |\ |\
=COUNTIF({Portfolio Summary Rollup Sheet Range 1}, |\ |\ |\ |\ |\
"Red") is correct. This formula uses the COUNTIF function
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
to count the number of campaigns with a health status of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
red in a particular portfolio. Formulas that are looking at
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the Symbol column type, such as the Health column in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
this scenario, require each symbol's color to be
|\ |\ |\ |\ |\ |\ |\ |\
capitalized.
Danielle would like to have her entire department review
|\ |\ |\ |\ |\ |\ |\ |\ |\
a report weekly. Additionally, even though there are a few
|\ |\ |\ |\ |\ |\ |\ |\ |\
associates who don't have access to Smartsheet,
|\ |\ |\ |\ |\ |\ |\ |\
Danielle wants to ensure that everyone has access to an
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
up-to-date version of the report at any time. What is the |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
recommended action for Danielle to take? |\ |\ |\ |\ |\
,Send the report as an attachment as a weekly recurrence
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and include the published link in the body of the message
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
is correct. Reports can be sent to any email address as an
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
attachment on a weekly basis without having to give
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
anyone access to the report itself. Publishing the report
|\ |\ |\ |\ |\ |\ |\ |\ |\
and including the link in the body of the weekly
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
notification allows anyone to access the up-to-date- |\ |\ |\ |\ |\ |\
version of the report at any time. |\ |\ |\ |\ |\ |\
Celina is looking to lock in a column value in the following
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
formula, so that she could apply the formula to any row
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and it would still reference the same column:
|\ |\ |\ |\ |\ |\ |\
=IF([%Complete]@row=1, "Green", "Yellow") |\ |\
What should Celina add to the formula?
|\ |\ |\ |\ |\ |\
=IF($[%Complete]@row=1, "Green", "Yellow") is correct. |\ |\ |\ |\ |\
The $ is an absolute reference. In this case, the absolute
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
reference should appear before the column %Complete, |\ |\ |\ |\ |\ |\ |\
which will tell the formula to always reference the
|\ |\ |\ |\ |\ |\ |\ |\ |\
%Complete column regardless of the cell the formula is |\ |\ |\ |\ |\ |\ |\ |\ |\
in.
Ken is building an event schedule. He would like everyone
|\ |\ |\ |\ |\ |\ |\ |\ |\
to simultaneously see the whole schedule at one time but
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
also allow each team member to focus on their own tasks
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
immediately.
|\
,Which is the most efficient way to accomplish this?
|\ |\ |\ |\ |\ |\ |\ |\
Create conditional formatting to assign a color to each
|\ |\ |\ |\ |\ |\ |\ |\ |\
team member is correct. If the sheet has an Assigned To
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
column that lists which team member has been assigned
|\ |\ |\ |\ |\ |\ |\ |\ |\
to each task, Ken can use conditional formatting to
|\ |\ |\ |\ |\ |\ |\ |\ |\
associate each teammate's name to a color. This way |\ |\ |\ |\ |\ |\ |\ |\ |\
each teammate can see the whole schedule while only
|\ |\ |\ |\ |\ |\ |\ |\ |\
focusing on their assigned color. |\ |\ |\ |\
Carson is creating a form to collect requests for IT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
equipment and software support from employees at their |\ |\ |\ |\ |\ |\ |\ |\
organization. The source sheet has the following columns: |\ |\ |\ |\ |\ |\ |\
Request Type, Equipment, Date Needed, Software, and
|\ |\ |\ |\ |\ |\ |\ |\
Issue. If an employee selects IT Equipment from the
|\ |\ |\ |\ |\ |\ |\ |\ |\
Request Type field, they need to submit answers for the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Equipment and Date Needed columns. If they select IT |\ |\ |\ |\ |\ |\ |\ |\ |\
Software Support from the Request Type field, they need
|\ |\ |\ |\ |\ |\ |\ |\ |\
to submit answers for the Software and Issue fields. What
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
is the recommended way for Carson to set up their form
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
to ensure they collect the responses they need?
|\ |\ |\ |\ |\ |\ |\
Add form logic to the Request Type field is correct. Carson
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
should add two rules to the logic for the Request Type
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
field:
, Mary is setting up a project schedule with predecessors
|\ |\ |\ |\ |\ |\ |\ |\ |\
and has created an Overdue column with a formula that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
calculates how many days a task is overdue. Now she |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
wants to visualize the severity of the delay, depending on
|\ |\ |\ |\ |\ |\ |\ |\ |\
how many days a task is overdue. What is the most
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
efficient way to accomplish this? |\ |\ |\ |\
Create conditional formatting rules that assign a color to
|\ |\ |\ |\ |\ |\ |\ |\ |\
a row based on how many days a task is overdue is
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
correct. Creating conditional formatting rules allows Mary
|\ |\ |\ |\ |\ |\ |\
to assign a different color for different ranges of days that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
each task is overdue.
|\ |\ |\ |\
Benjy wants his associates to be able to update the status
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
of their tasks on a report he has built. He also wants this
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
updated information to appear on the underlying sheets. |\ |\ |\ |\ |\ |\ |\ |\
What does Benjy need to do to ensure his associates can
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
update both the report and the underlying sheets? |\ |\ |\ |\ |\ |\ |\
Grant all associates Editor or higher permissions on the
|\ |\ |\ |\ |\ |\ |\ |\ |\
report and the underlying sheets is correct. Users must
|\ |\ |\ |\ |\ |\ |\ |\ |\
have at least Editor permissions on both the report and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the source sheet(s) to edit info in a report, which will then
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
populate back to the source sheets.
|\ |\ |\ |\ |\ |\
Juan is looking to automate the symbols that are
|\ |\ |\ |\ |\ |\ |\ |\ |\
produced in his Health column. He applies a nested IF |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
