Smartsheet Core Product Certification
Xiao is trying to create a metrics sheet
that will calculate the health of all the =COUNTIF({Portfolio Summary Rollup
current ongoing campaigns in her mar- Sheet Range 1}, "Red") is correct. This
keting portfolio. She has a Health column formula uses the COUNTIF function to
in each campaign's sheet and is using count the number of campaigns with a
the Symbol column type to indicate red, health status of red in a particular portfo-
yellow, or green for the health status. lio. Formulas that are looking at the Sym-
Which of the following formulas should bol column type, such as the Health col-
Xiao use in her metrics sheet to calcu- umn in this scenario, require each sym-
late how many campaigns have a health bol's color to be capitalized.
status of red?
Send the report as an attachment as a
Danielle would like to have her en- weekly recurrence and include the pub-
tire department review a report week- lished link in the body of the message is
ly. Additionally, even though there are correct. Reports can be sent to any email
a few associates who don't have ac- address as an attachment on a weekly
cess to Smartsheet, Danielle wants to basis without having to give anyone ac-
ensure that everyone has access to an cess to the report itself. Publishing the
up-to-date version of the report at any report and including the link in the body
time. What is the recommended action of the weekly notification allows anyone
for Danielle to take? to access the up-to-date-version of the
report at any time.
Celina is looking to lock in a column val- =IF($[%Complete]@row=1, "Green",
ue in the following formula, so that she "Yellow") is correct. The $ is an absolute
could apply the formula to any row and it reference. In this case, the absolute ref-
would still reference the same column: erence should appear before the column
=IF([%Complete]@row=1, "Green", "Yel- %Complete, which will tell the formula to
low") always reference the %Complete column
What should Celina add to the formula? regardless of the cell the formula is in.
Create conditional formatting to assign
Ken is building an event schedule. He
a color to each team member is cor-
would like everyone to simultaneously
rect. If the sheet has an Assigned To col-
see the whole schedule at one time but
umn that lists which team member has
also allow each team member to focus
been assigned to each task, Ken can
on their own tasks immediately.
use conditional formatting to associate
Which is the most efficient way to accom-
each teammate's name to a color. This
plish this?
way each teammate can see the whole
, Smartsheet Core Product Certification
schedule while only focusing on their as-
signed color.
Carson is creating a form to collect re-
quests for IT equipment and software
support from employees at their orga-
nization. The source sheet has the fol-
lowing columns: Request Type, Equip-
ment, Date Needed, Software, and Is-
sue. If an employee selects IT Equipment
Add form logic to the Request Type field
from the Request Type field, they need
is correct. Carson should add two rules
to submit answers for the Equipment and
to the logic for the Request Type field:
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?
Mary is setting up a project schedule
Create conditional formatting rules that
with predecessors and has created an
assign a color to a row based on how
Overdue column with a formula that cal-
many days a task is overdue is correct.
culates how many days a task is overdue.
Creating conditional formatting rules al-
Now she wants to visualize the severity
lows Mary to assign a different color for
of the delay, depending on how many
different ranges of days that each task is
days a task is overdue. What is the most
overdue.
efficient way to accomplish this?
Benjy wants his associates to be able
Grant all associates Editor or higher per-
to update the status of their tasks on a
missions on the report and the underly-
report he has built. He also wants this
ing sheets is correct. Users must have
updated information to appear on the un-
at least Editor permissions on both the
derlying sheets. What does Benjy need
report and the source sheet(s) to edit info
to do to ensure his associates can up-
in a report, which will then populate back
date both the report and the underlying
to the source sheets.
sheets?
The formula contains a misspelling, uses
the wrong case for column names, or
misapplies quotation marks. is correct.
An #UNPARSEABLE error is displayed
, Smartsheet Core Product Certification
when the formula has a problem which
Juan is looking to automate the sym-
prevents it from being parsed and inter-
bols that are produced in his Health col-
preted. This can happen for many rea-
umn. He applies a nested IF formula,
sons, such as misspelling, incomplete
but the formula is returning an #UN-
operators, using the wrong case for a
PARSEABLE response. What is most
column name, or using single quotes in-
likely the cause of the error message?
stead of double quotes.
Benjamin is creating an IF formula to dis-
play specific Health symbols based on
The cell reference of the % Complete in
conditions in his sheet. When a task has
the formula does not have square brack-
a value of 100% in the % Complete col-
ets. is correct. All cell references in for-
umn, he wants to show the green sym-
mulas must have square brackets if the
bol. He is sure he typed in the correct for-
column name consists of more than 1
mula but gets an #UNPARSEABLE error
word or includes special characters.
message. What is the most likely cause
for the error message?
Priya is calculating profits for her small
business. In her tracking sheet for sales,
Make the formula a column formula is
she uses this formula to calculate the
correct. To ensure any new rows added
profit for each sale:
to the sheet have this formula applied,
=[Quoted Amount]@row - [Actual
Priya should right-click a cell containing
Cost]@rowShe wants to ensure that all
this formula, then choose Convert to Col-
future sales apply this formula automat-
umn Formula from the menu options.
ically. What is the most efficient way for
her to accomplish this?
Bridget would like to group the tasks in
The Assigned To column is a multi select
her report based on the Assigned To col-
contact column. is correct. Multi select
umn, but that column is not shown as
columns cannot be used for grouping in
an option in the Group by dropdown list.
reports.
What is the most likely reason for this?
Damian has a dashboard tracking the Turn on Auto-Refresh and display the
status of several open IT tickets. He dashboard in presentation mode is cor-
wants to display the status of these tick- rect. Turning on Auto-Refresh will ensure
ets on a screen in the office so that his the display gets updated at specific inter-
department can view their workload in vals. Displaying the dashboard in presen-
real time. How can Damian accomplish tation mode ensures an optimized view-
this? ing experience for the department.
Xiao is trying to create a metrics sheet
that will calculate the health of all the =COUNTIF({Portfolio Summary Rollup
current ongoing campaigns in her mar- Sheet Range 1}, "Red") is correct. This
keting portfolio. She has a Health column formula uses the COUNTIF function to
in each campaign's sheet and is using count the number of campaigns with a
the Symbol column type to indicate red, health status of red in a particular portfo-
yellow, or green for the health status. lio. Formulas that are looking at the Sym-
Which of the following formulas should bol column type, such as the Health col-
Xiao use in her metrics sheet to calcu- umn in this scenario, require each sym-
late how many campaigns have a health bol's color to be capitalized.
status of red?
Send the report as an attachment as a
Danielle would like to have her en- weekly recurrence and include the pub-
tire department review a report week- lished link in the body of the message is
ly. Additionally, even though there are correct. Reports can be sent to any email
a few associates who don't have ac- address as an attachment on a weekly
cess to Smartsheet, Danielle wants to basis without having to give anyone ac-
ensure that everyone has access to an cess to the report itself. Publishing the
up-to-date version of the report at any report and including the link in the body
time. What is the recommended action of the weekly notification allows anyone
for Danielle to take? to access the up-to-date-version of the
report at any time.
Celina is looking to lock in a column val- =IF($[%Complete]@row=1, "Green",
ue in the following formula, so that she "Yellow") is correct. The $ is an absolute
could apply the formula to any row and it reference. In this case, the absolute ref-
would still reference the same column: erence should appear before the column
=IF([%Complete]@row=1, "Green", "Yel- %Complete, which will tell the formula to
low") always reference the %Complete column
What should Celina add to the formula? regardless of the cell the formula is in.
Create conditional formatting to assign
Ken is building an event schedule. He
a color to each team member is cor-
would like everyone to simultaneously
rect. If the sheet has an Assigned To col-
see the whole schedule at one time but
umn that lists which team member has
also allow each team member to focus
been assigned to each task, Ken can
on their own tasks immediately.
use conditional formatting to associate
Which is the most efficient way to accom-
each teammate's name to a color. This
plish this?
way each teammate can see the whole
, Smartsheet Core Product Certification
schedule while only focusing on their as-
signed color.
Carson is creating a form to collect re-
quests for IT equipment and software
support from employees at their orga-
nization. The source sheet has the fol-
lowing columns: Request Type, Equip-
ment, Date Needed, Software, and Is-
sue. If an employee selects IT Equipment
Add form logic to the Request Type field
from the Request Type field, they need
is correct. Carson should add two rules
to submit answers for the Equipment and
to the logic for the Request Type field:
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?
Mary is setting up a project schedule
Create conditional formatting rules that
with predecessors and has created an
assign a color to a row based on how
Overdue column with a formula that cal-
many days a task is overdue is correct.
culates how many days a task is overdue.
Creating conditional formatting rules al-
Now she wants to visualize the severity
lows Mary to assign a different color for
of the delay, depending on how many
different ranges of days that each task is
days a task is overdue. What is the most
overdue.
efficient way to accomplish this?
Benjy wants his associates to be able
Grant all associates Editor or higher per-
to update the status of their tasks on a
missions on the report and the underly-
report he has built. He also wants this
ing sheets is correct. Users must have
updated information to appear on the un-
at least Editor permissions on both the
derlying sheets. What does Benjy need
report and the source sheet(s) to edit info
to do to ensure his associates can up-
in a report, which will then populate back
date both the report and the underlying
to the source sheets.
sheets?
The formula contains a misspelling, uses
the wrong case for column names, or
misapplies quotation marks. is correct.
An #UNPARSEABLE error is displayed
, Smartsheet Core Product Certification
when the formula has a problem which
Juan is looking to automate the sym-
prevents it from being parsed and inter-
bols that are produced in his Health col-
preted. This can happen for many rea-
umn. He applies a nested IF formula,
sons, such as misspelling, incomplete
but the formula is returning an #UN-
operators, using the wrong case for a
PARSEABLE response. What is most
column name, or using single quotes in-
likely the cause of the error message?
stead of double quotes.
Benjamin is creating an IF formula to dis-
play specific Health symbols based on
The cell reference of the % Complete in
conditions in his sheet. When a task has
the formula does not have square brack-
a value of 100% in the % Complete col-
ets. is correct. All cell references in for-
umn, he wants to show the green sym-
mulas must have square brackets if the
bol. He is sure he typed in the correct for-
column name consists of more than 1
mula but gets an #UNPARSEABLE error
word or includes special characters.
message. What is the most likely cause
for the error message?
Priya is calculating profits for her small
business. In her tracking sheet for sales,
Make the formula a column formula is
she uses this formula to calculate the
correct. To ensure any new rows added
profit for each sale:
to the sheet have this formula applied,
=[Quoted Amount]@row - [Actual
Priya should right-click a cell containing
Cost]@rowShe wants to ensure that all
this formula, then choose Convert to Col-
future sales apply this formula automat-
umn Formula from the menu options.
ically. What is the most efficient way for
her to accomplish this?
Bridget would like to group the tasks in
The Assigned To column is a multi select
her report based on the Assigned To col-
contact column. is correct. Multi select
umn, but that column is not shown as
columns cannot be used for grouping in
an option in the Group by dropdown list.
reports.
What is the most likely reason for this?
Damian has a dashboard tracking the Turn on Auto-Refresh and display the
status of several open IT tickets. He dashboard in presentation mode is cor-
wants to display the status of these tick- rect. Turning on Auto-Refresh will ensure
ets on a screen in the office so that his the display gets updated at specific inter-
department can view their workload in vals. Displaying the dashboard in presen-
real time. How can Damian accomplish tation mode ensures an optimized view-
this? ing experience for the department.
