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