Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
1. Xiao is trying to cre- =COUNTIF({Portfolio Summary Rollup Sheet Range 1}, "Red") is correct.
ate a metrics sheet This formula uses the COUNTIF function to count the number of campaigns
that will calculate the with a health status of red in a particular portfolio. Formulas that are looking
health of all the cur- at the Symbol column type, such as the Health column in this scenario,
rent ongoing cam- require each symbol's color to be capitalized.
paigns in her mar-
keting portfolio. She
has a Health col-
umn in each cam-
paign's sheet and is
using the Symbol col-
umn type to indicate
red, yellow, or green
for the health status.
Which of the follow-
ing formulas should
Xiao use in her met-
rics sheet to calculate
how many campaigns
have a health status
of red?
2. Danielle would like Send the report as an attachment as a weekly recurrence and include the
to have her entire published link in the body of the message is correct. Reports can be sent
department review a to any email address as an attachment on a weekly basis without having to
report weekly. Addi- give anyone access to the report itself. Publishing the report and including
tionally, even though the link in the body of the weekly notification allows anyone to access the
there are a few asso- up-to-date-version of the report at any time.
ciates who don't have
access to Smartsheet,
Danielle wants to en-
sure that everyone
, Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
has access to an
up-to-date version of
the report at any
time. What is the rec-
ommended action for
Danielle to take?
3. Celina is looking to =IF($[%Complete]@row=1, "Green", "Yellow") is correct. The $ is an ab-
lock in a column val- solute reference. In this case, the absolute reference should appear before
ue in the following the column %Complete, which will tell the formula to always reference the
formula, so that she %Complete column regardless of the cell the formula is in.
could apply the for-
mula to any row and
it would still reference
the same column:
=IF([%Com-
plete]@row=1,
"Green", "Yellow")
What should Celina
add to the formula?
4. Ken is building an Create conditional formatting to assign a color to each team member is
event schedule. He correct. If the sheet has an Assigned To column that lists which team mem-
would like everyone ber has been assigned to each task, Ken can use conditional formatting to
to simultaneously see associate each teammate's name to a color. This way each teammate can
the whole schedule at see the whole schedule while only focusing on their assigned color.
one time but also al-
low each team mem-
ber to focus on their
own tasks immediate-
ly.
Which is the most ef-
, Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
ficient way to accom-
plish this?
5. Carson is creating a Add form logic to the Request Type field is correct. Carson should add two
form to collect re- rules to the logic for the Request Type field:
quests for IT equip-
ment and software
support from employ-
ees at their orga-
nization. The source
sheet has the fol-
lowing columns: Re-
quest Type, Equip-
ment, Date Need-
ed, Software, and Is-
sue. If an employ-
ee selects IT Equip-
ment from the Re-
quest Type field, they
need to submit an-
swers for the Equip-
ment and Date Need-
ed columns. If they
select IT Software
Support from the Re-
quest Type field, they
need to submit an-
swers for the Soft-
ware and Issue fields.
What is the recom-
mended way for Car-
son to set up their
, Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
form to ensure they
collect the responses
they need?
6. Mary is setting up a Create conditional formatting rules that assign a color to a row based on
project schedule with how many days a task is overdue is correct. Creating conditional formatting
predecessors and has rules allows Mary to assign a different color for different ranges of days
created an Overdue that each task is overdue.
column with a for-
mula 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?
7. Benjy wants his asso- Grant all associates Editor or higher permissions on the report and the
ciates to be able to underlying sheets is correct. Users must have at least Editor permissions
update the status of on both the report and the source sheet(s) to edit info in a report, which
their tasks on a re- will then populate back to the source sheets.
port he has built. He
also wants this updat-
ed information to ap-
pear on the underly-
ing sheets. What does
Benjy need to do to
ensure his associates
can update both the
Study online at https://quizlet.com/_gntnjx
1. Xiao is trying to cre- =COUNTIF({Portfolio Summary Rollup Sheet Range 1}, "Red") is correct.
ate a metrics sheet This formula uses the COUNTIF function to count the number of campaigns
that will calculate the with a health status of red in a particular portfolio. Formulas that are looking
health of all the cur- at the Symbol column type, such as the Health column in this scenario,
rent ongoing cam- require each symbol's color to be capitalized.
paigns in her mar-
keting portfolio. She
has a Health col-
umn in each cam-
paign's sheet and is
using the Symbol col-
umn type to indicate
red, yellow, or green
for the health status.
Which of the follow-
ing formulas should
Xiao use in her met-
rics sheet to calculate
how many campaigns
have a health status
of red?
2. Danielle would like Send the report as an attachment as a weekly recurrence and include the
to have her entire published link in the body of the message is correct. Reports can be sent
department review a to any email address as an attachment on a weekly basis without having to
report weekly. Addi- give anyone access to the report itself. Publishing the report and including
tionally, even though the link in the body of the weekly notification allows anyone to access the
there are a few asso- up-to-date-version of the report at any time.
ciates who don't have
access to Smartsheet,
Danielle wants to en-
sure that everyone
, Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
has access to an
up-to-date version of
the report at any
time. What is the rec-
ommended action for
Danielle to take?
3. Celina is looking to =IF($[%Complete]@row=1, "Green", "Yellow") is correct. The $ is an ab-
lock in a column val- solute reference. In this case, the absolute reference should appear before
ue in the following the column %Complete, which will tell the formula to always reference the
formula, so that she %Complete column regardless of the cell the formula is in.
could apply the for-
mula to any row and
it would still reference
the same column:
=IF([%Com-
plete]@row=1,
"Green", "Yellow")
What should Celina
add to the formula?
4. Ken is building an Create conditional formatting to assign a color to each team member is
event schedule. He correct. If the sheet has an Assigned To column that lists which team mem-
would like everyone ber has been assigned to each task, Ken can use conditional formatting to
to simultaneously see associate each teammate's name to a color. This way each teammate can
the whole schedule at see the whole schedule while only focusing on their assigned color.
one time but also al-
low each team mem-
ber to focus on their
own tasks immediate-
ly.
Which is the most ef-
, Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
ficient way to accom-
plish this?
5. Carson is creating a Add form logic to the Request Type field is correct. Carson should add two
form to collect re- rules to the logic for the Request Type field:
quests for IT equip-
ment and software
support from employ-
ees at their orga-
nization. The source
sheet has the fol-
lowing columns: Re-
quest Type, Equip-
ment, Date Need-
ed, Software, and Is-
sue. If an employ-
ee selects IT Equip-
ment from the Re-
quest Type field, they
need to submit an-
swers for the Equip-
ment and Date Need-
ed columns. If they
select IT Software
Support from the Re-
quest Type field, they
need to submit an-
swers for the Soft-
ware and Issue fields.
What is the recom-
mended way for Car-
son to set up their
, Smartsheet Core Product Certification
Study online at https://quizlet.com/_gntnjx
form to ensure they
collect the responses
they need?
6. Mary is setting up a Create conditional formatting rules that assign a color to a row based on
project schedule with how many days a task is overdue is correct. Creating conditional formatting
predecessors and has rules allows Mary to assign a different color for different ranges of days
created an Overdue that each task is overdue.
column with a for-
mula 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?
7. Benjy wants his asso- Grant all associates Editor or higher permissions on the report and the
ciates to be able to underlying sheets is correct. Users must have at least Editor permissions
update the status of on both the report and the source sheet(s) to edit info in a report, which
their tasks on a re- will then populate back to the source sheets.
port he has built. He
also wants this updat-
ed information to ap-
pear on the underly-
ing sheets. What does
Benjy need to do to
ensure his associates
can update both the
