Smartsheet Project Management Certification Exam (New 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Graded A
Smartsheet Project Management
Certification Exam (New 2023/ 2024
Update) Questions and Verified Answers|
100% Correct| Graded A
QUESTION
which is the correct syntax to further customize the message in an alert using placeholders?
Answer:
{{Task Name}}
QUESTION
what is a roll up sheet?
Answer:
similar to a metric sheet and allows aggregation of the most important project data for each of
the projects in our portfolio.
QUESTION
which is the best way to allow the standardization of managing the projects in your portfolio?
Answer:
creating a template folder that contains all assets needed to manage a project ad cam be
duplicated for each new project
QUESTION
How can a helper column be used?
Answer:
- to simplify an analysis
-to create a work breakdown structure
-to complete a calculation
QUESTION
what smartsheet function allows you to add information to your project sheet without adding
rows to your grid?
Answer:
Sheet summary
QUESTION
what columns will smartsheet add on your behalf when starting from a blank grid and enabling
dependencies?
Answer:
-Predecessors
-Duration
QUESTION
what will smartshet do if a task is marked with elapsed time?
Answer:
count every day as a working day
QUESTION
SF
Answer:
SF is a relationship more of a work-back schedule. assumes a fixed end point or completion date
(event planning)
QUESTION
FF
Answer:
Powered by https://learnexams.com/search/study?query=
what option would you choose to let users submit multiple form responses?
In the settings tab under form submission select the reload the same form for another submission
how can you prefill a value on a field for a user to change if they wish?
Set as default value
In the sheet summary you are countng the number of submission that are open, completed and in progress. what is a disadvantage of creating a workflow that moves completed tasks to a resolved/completed sheet?
you will loose metrics you may still want to track
A form is based on
a sheet
you want to display the latest comment made for all rows automatically, which column type should you choose?
latest comment
you have a form showing a status field that should always be set to “not started” when the user submits the form. what is the easiest way that you prevent your users from changing this value?
One the form, set the hidden and set the default value to “not started”
How do you create a form?
Click forms on the menu bar, then click create forms.
what column type can you use to enumerate row submission for later reference?
auto number
how would you send a quick update for a specific row?
select the row(s), then select the send option from the row menu.
for what purpose would you use groups in Smartsheet?
To share an item in workspace
how do you rest the baseline?
go to Gant View, click baseline icon in the tool bar, then click reset baseline dialog box.
how can you send your sheet as an attachment?
from the file menu select send as an attachment option.
how do you add members to a group you created?
go to account settings, and click Group Management. Then click the pencil icon to add group members.
what are the steps to publish a sheet?
click the publish icon on the right toolbar, click the slider for the desired publish option.
what are 2 ways to add attachments?
click the paper clip icon in front of a row, or click the paper clip icon in the right feature bar
how do you turn on the baseline
go to the gant view and lick the baselines icon in the top toolbar
what is the correct syntax to show partial working days in the duration column?
3.5 d
how do you create a milestone?
type 0 in the duration column
when would you use the SS task relationship
when you plan to have two or more tasks start at the same time
how do you show the critical path on the gant view.
click the critical path icon in the top right of the sheet.
what is the default type for tasks relationships?
FS
What is the WBS in terms of Project management?
It is a method of organising work in a project
what is the critical path
the critical path of a project is a sequenced list of tasks that must be completed on time in order for the project to meet its deadline
when would you use the FF task relationship?
when you plan to have two or more tasks finish at the same time
what is the purpose of adding lag time to your tasks
to represent a period of inactivity between the predecessor and dependent tasks.
what is the purpose of adding lead time to your tasks?
to represent a period of overlap between the predecessor and the dependent.
how do you access the sheet summary?
click the summary icon on the right feature bar.
what is the advantage of creating metrics in a metric sheet instead of the project sheet?
Creating metrics in the project sheet may cause data and formulas to be accidentally deleted or changed.
what does ISCRITICAL function do?
It identifies whether a row is on the Critical Path.
How do you create the critical path?
in the filter on the toolbar, under show rows that match, select “row” and is on Critical Path as conditions.
the total float calculates the number of days that a task can be delayed without impacting the Project finish date.
TOTALFLOAT([Task Name]@row)
what is the correct formula if you want to count all of the ancestors in a cell’s hierarchy?
COUNT(ANCESTORS([Value 1]@row)
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?
IF(AND([End Date]@row,TODAY(), NOT(Status@row=”Complete”)),1,0)
which formula is the correct function to calculate the direct sucessors of a task and return the succeding tasks row numbers?
JOIN(SUCCESSORS([Task Name]@row),”,”)
how do you convert a cell formula to a column formula?
After writing the formula, right-click the cell to open the call menu and select the convert to column formula option.
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?
Sheet summary report
which widget allow you to enter and format any text string that you want to use for titles, instructions, updates, or any other type of test, such as hyperlinks.
Rich text widget
what is the correct option when you want people in your organization to see the same data as the person who created the widget?
last widget editor
which access control feature for publish options has the potential to expose sensitive data outside of your company?
available to anyone with the link
which filter option would you choose to create a current user report?
Assigned To has any of Current User
which permission levels can create or edit approval request rules?
Owner or Admin
copying a sheet using the Save as New option from the file menu, how can you ensure the copied sheet is shared to the same collaborators as the original?
in the save as new dialog, select sharing in the sharing options section.
which is the correct syntax to further customize the message in an alert using placeholders?
{{Task Name}}
what is a roll up sheet?
similar to a metric sheet and allows aggregation of the most important project data for each of the projects in our portfolio.
which is the best way to allow the standardization of managing the projects in your portfolio?
creating a template folder that contains all assets needed to manage a project ad cam be duplicated for each new project
How can a helper column be used?
- to simplify an analysis
-to create a work breakdown structure
-to complete a calculation
what smartsheet function allows you to add information to your project sheet without adding rows to your grid?
Sheet summary
what columns will smartsheet add on your behalf when starting from a blank grid and enabling dependencies?
-Predecessors
-Duration
what will smartshet do if a task is marked with elapsed time?
count every day as a working day
SF
SF is a relationship more of a work-back schedule. assumes a fixed end point or completion date (event planning)
FF
The FF relationship means, the first task (predecessor) must have finished before the next task (successor) can finish They do not have to finish at the same time.
SS
SS relationship means the predecessors must be started before the successor an start, not that both tasks MUST start t the same time (that can happen but it does not have to_
Lead time
some tasks do not have to be completely finished before the next one starts. the successor task overlaps with the predecessor by X days. Lead tim adds intentional overlap between tasks.s
lag time
adds intentional time between tasks. the added time is a period of inactivity.
summary path
shows which subtasks affect the completion date of a particular summary (parent) row – dependencies must first be enabled on th sheet to use the summanry path (orange)
driving path
shows which predecessor task affects the start date of a particular task, dependencies must first be enabled on the sheet. to see which tasks are on the driving path, right click on the taskbar on the gant chart.
when a baseline is set what column is added to the grid?
variance
when should the project baseline be set?
after task, dates, duration, and prececessros are established.
How can the “run now” option be accessed to test workflow automation?
3 dot menu of any workflow and it is easy way to test automation
IF
evaluates a logical expression and returns one value when true or another when false
AND
used within another function to return true if provided logical expressions are true
OR
used within another function to return true if at least one provided logical expression is true
NESTING IF
allow to perform calculations on values in multiple cells
COUNTIF
Counts the number of cells within a range that meet the given condition
COUNTIFS
counts the number of times all given conditions in their respective ranges are met
- can use to exclude the count of parent rows
Total Float()
calculates the number of days that a task can be delayed without impacting the Project Finish Date.
Negative float is the amount of time that must be saved to bring the project to completion on time.
Sucessors()
calculates direct successors to the given task the tasks that are directly dependent on a specific task. the formula returns a collection of values that will occur as a result of the referenced task.
IsCritical()
returns true if the task in on the critical path
sources;
https://www.gcu.edu/
https://yaveni.com/
https://www.rasmussen.edu/
https://www.chamberlain.edu/