Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
Taryn created a report to view the tasks she's assigned to across multiple project
plans. However, she cannot see which projects or phases the tasks are associated
with. Taryn wants to add a column to the sheets with a formula that automatically
displays the project name and phase name next to each task, then add that column
to her report. What formula should Taryn use?
A: =JOIN(PARENT([Task Name]@row), " - ")
B: =PARENT([Task Name]@row)
C: =ANCESTORS([Task Name]@row)
D: =JOIN(ANCESTORS([Task Name]@row), " - ")
A: =JOIN(PARENT([Task Name]@row), " - ")
The ANCESTORS() function returns an array of all ancestor
rows of the current task row, which would include both the project name and the
phase name if they are organized
hierarchically above the task. The JOIN() function then concatenates these ancestor
values into a single string,
separated by " - ". This provides a complete reference to the project and phase for
each task.
, Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
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?
A: The % Complete column is locked.
B: The Health column is a symbol column, which does not allow formulas.
C: The Health column is locked.
D: The cell reference of the % Complete in the formula does not have square
brackets.
D: The cell reference of the % Complete in the formula does not have square
brackets.
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]@row
, Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
She wants to ensure that all future sales apply this formula automatically.
What is the most efficient way for her to accomplish this?
A: Create a conditional formatting rule
B: Make the formula a column formula
C: Copy the previous row and update the data for each new sale
D: Create an automation
B: Make the formula a column formula
To ensure any new rows added to the sheet have this formula applied, Priya should
right-click a cell containing this formula, then choose Convert to Column Formula
from the menu options.
Amy is a project manager who is looking at a report of the current status for all of
her department's project schedules. She wants to update the projected completion
date in the report for one of the projects but she is unable to edit that field in the
report. What would cause Amy to be unable to edit the date in the report?
A: The end dates in the underlying sheets are based on dependencies
B: The underlying sheets contain row hierarchies.
C: Amy has Editor permissions on the underlying sheets.
, Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
D: The underlying sheets contain conditional formatting
A: The end dates in the underlying sheets are based on dependencies
If dependencies are enabled in a sheet, users have to manually update the start date
or duration in the sheet. It is not possible to update the end date in a sheet or report
built on dependencies.
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?
A: Create a Current User filter in the report for each associate
B: Grant all associates Editor or higher permissions on the report and the
underlying sheets
C: Create a Sheet Summary report for all the underlying sheets and share all
associates to it
D: Grant all associates Admin or higher permissions on the report and underlying
sheets
B: Grant all associates Editor or higher permissions on the report and the
underlying sheets
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
Taryn created a report to view the tasks she's assigned to across multiple project
plans. However, she cannot see which projects or phases the tasks are associated
with. Taryn wants to add a column to the sheets with a formula that automatically
displays the project name and phase name next to each task, then add that column
to her report. What formula should Taryn use?
A: =JOIN(PARENT([Task Name]@row), " - ")
B: =PARENT([Task Name]@row)
C: =ANCESTORS([Task Name]@row)
D: =JOIN(ANCESTORS([Task Name]@row), " - ")
A: =JOIN(PARENT([Task Name]@row), " - ")
The ANCESTORS() function returns an array of all ancestor
rows of the current task row, which would include both the project name and the
phase name if they are organized
hierarchically above the task. The JOIN() function then concatenates these ancestor
values into a single string,
separated by " - ". This provides a complete reference to the project and phase for
each task.
, Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
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?
A: The % Complete column is locked.
B: The Health column is a symbol column, which does not allow formulas.
C: The Health column is locked.
D: The cell reference of the % Complete in the formula does not have square
brackets.
D: The cell reference of the % Complete in the formula does not have square
brackets.
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]@row
, Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
She wants to ensure that all future sales apply this formula automatically.
What is the most efficient way for her to accomplish this?
A: Create a conditional formatting rule
B: Make the formula a column formula
C: Copy the previous row and update the data for each new sale
D: Create an automation
B: Make the formula a column formula
To ensure any new rows added to the sheet have this formula applied, Priya should
right-click a cell containing this formula, then choose Convert to Column Formula
from the menu options.
Amy is a project manager who is looking at a report of the current status for all of
her department's project schedules. She wants to update the projected completion
date in the report for one of the projects but she is unable to edit that field in the
report. What would cause Amy to be unable to edit the date in the report?
A: The end dates in the underlying sheets are based on dependencies
B: The underlying sheets contain row hierarchies.
C: Amy has Editor permissions on the underlying sheets.
, Smartsheet Core Product Certification Exam (New
2023/ 2024 Update) Questions and Answers with
Rationales | 100% Correct| Graded A (Verified
Solutions)
D: The underlying sheets contain conditional formatting
A: The end dates in the underlying sheets are based on dependencies
If dependencies are enabled in a sheet, users have to manually update the start date
or duration in the sheet. It is not possible to update the end date in a sheet or report
built on dependencies.
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?
A: Create a Current User filter in the report for each associate
B: Grant all associates Editor or higher permissions on the report and the
underlying sheets
C: Create a Sheet Summary report for all the underlying sheets and share all
associates to it
D: Grant all associates Admin or higher permissions on the report and underlying
sheets
B: Grant all associates Editor or higher permissions on the report and the
underlying sheets
