Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
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.
, Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
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
, Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
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.
, Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
Juan is looking to automate the symbols that are produced in his Health column.
He applies a nested IF formula, but the formula is returning an #UNPARSEABLE
response. What is most likely the cause of the error message?
The formula contains a misspelling, uses the wrong case for column names, or
misapplies quotation marks. is correct. An #UNPARSEABLE error is displayed
when the formula has a problem which prevents it from being parsed and
interpreted. This can happen for many reasons, such as misspelling, incomplete
operators, using the wrong case for a column name, or using single quotes instead
of double quotes.
Benjamin is creating an IF formula to display specific Health symbols based on
conditions in his sheet. When a task has a value of 100% in the % Complete
column, he wants to show the green symbol. He is sure he typed in the correct
formula but gets an #UNPARSEABLE error message. What is the most likely
cause for the error message?
The cell reference of the % Complete in the formula does not have square brackets.
is correct. All cell references in formulas must have square brackets if the column
name consists of more than 1 word or includes special characters.
Priya is calculating profits for her small business. In her tracking sheet for sales,
she uses this formula to calculate the profit for each sale:
=[Quoted Amount]@row - [Actual Cost]@rowShe wants to ensure that all future
sales apply this formula automatically. What is the most efficient way for her to
accomplish this?
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
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.
, Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
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
, Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
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.
, Smartsheet Core Product Certification Exam V1
(Latest Update) Questions and Answers | Actual Exam
1 | 100% Correct| Graded A (Verified Solutions)
Juan is looking to automate the symbols that are produced in his Health column.
He applies a nested IF formula, but the formula is returning an #UNPARSEABLE
response. What is most likely the cause of the error message?
The formula contains a misspelling, uses the wrong case for column names, or
misapplies quotation marks. is correct. An #UNPARSEABLE error is displayed
when the formula has a problem which prevents it from being parsed and
interpreted. This can happen for many reasons, such as misspelling, incomplete
operators, using the wrong case for a column name, or using single quotes instead
of double quotes.
Benjamin is creating an IF formula to display specific Health symbols based on
conditions in his sheet. When a task has a value of 100% in the % Complete
column, he wants to show the green symbol. He is sure he typed in the correct
formula but gets an #UNPARSEABLE error message. What is the most likely
cause for the error message?
The cell reference of the % Complete in the formula does not have square brackets.
is correct. All cell references in formulas must have square brackets if the column
name consists of more than 1 word or includes special characters.
Priya is calculating profits for her small business. In her tracking sheet for sales,
she uses this formula to calculate the profit for each sale:
=[Quoted Amount]@row - [Actual Cost]@rowShe wants to ensure that all future
sales apply this formula automatically. What is the most efficient way for her to
accomplish this?
