Smartsheet Project Management Certification Exam (Latest 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Grade A

Smartsheet Project Management

Certification Exam (Latest 2023/ 2024

Update) Questions and Verified Answers|

100% Correct| Grade A

Q: how do you access the sheet summary?

Answer:

click the summary icon on the right feature bar.

Q: what is the advantage of creating metrics in a metric sheet instead of the project sheet?

Answer:

Creating metrics in the project sheet may cause data and formulas to be accidentally deleted or

changed.

Q: what does ISCRITICAL function do?

Answer:

It identifies whether a row is on the

Critical Path.

Q: How do you create the critical path?

Answer:

in the filter on the toolbar, under show rows that match, select "row" and is on Critical Path as

conditions.

Q: the total float calculates the number of days that a task can be delayed without impacting the

Project finish date.

Answer:

TOTALFLOAT([Task Name]@row)

Q: what is the correct formula if you want to count all of the ancestors in a cell's hierarchy?

Answer:

COUNT(ANCESTORS([Value 1]@row)

Q: to automate a flag column so that it gets flagged when the end date of a task is in the past

and the status is not complete?

Answer:

IF(AND([End Date]@row,TO- DAY(), NOT(Status@row="Complete")),1,0)

Q: which formula is the correct function to calculate the direct sucessors of a task and return the

succeding tasks row numbers?

Answer:

JOIN(SUCCESSORS([Task Name]@row),",")

Q: how do you convert a cell formula to a column formula?

Answer:

After writing the formula, right-click the cell to open the call menu and select the convert to

column formula option.

Q: which report allows you to add field from one or more sheets into a single report so you can

see critical information in a single portfolio level view?

Answer:

Sheet summary report