-to create a work breakdown structure
-to complete a calculation<\/li>\n<\/ul>\n\n\n\n
QUESTION what option would you choose to let users submit multiple form responses? how can you prefill a value on a field for a user to change if they wish? 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? A form is based on you want to display the latest comment made for all rows automatically, which column type should you choose? 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? How do you create a form? what column type can you use to enumerate row submission for later reference? how would you send a quick update for a specific row? for what purpose would you use groups in Smartsheet? how do you rest the baseline? how can you send your sheet as an attachment? how do you add members to a group you created? what are the steps to publish a sheet? what are 2 ways to add attachments? how do you turn on the baseline what is the correct syntax to show partial working days in the duration column? how do you create a milestone? when would you use the SS task relationship how do you show the critical path on the gant view. what is the default type for tasks relationships? What is the WBS in terms of Project management? what is the critical path when would you use the FF task relationship? what is the purpose of adding lag time to your tasks what is the purpose of adding lead time to your tasks? how do you access the sheet summary? what is the advantage of creating metrics in a metric sheet instead of the project sheet? what does ISCRITICAL function do? How do you create the critical path? the total float calculates the number of days that a task can be delayed without impacting the Project finish date. what is the correct formula if you want to count all of the ancestors in a cell’s hierarchy? 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? which formula is the correct function to calculate the direct sucessors of a task and return the succeding tasks row numbers? how do you convert a cell formula to a column formula? 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? 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. what is the correct option when you want people in your organization to see the same data as the person who created the widget? which access control feature for publish options has the potential to expose sensitive data outside of your company? which filter option would you choose to create a current user report? which permission levels can create or edit approval request rules? 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? which is the correct syntax to further customize the message in an alert using placeholders? what is a roll up sheet? which is the best way to allow the standardization of managing the projects in your portfolio? How can a helper column be used?<\/p>\n\n\n\n what smartsheet function allows you to add information to your project sheet without adding rows to your grid? what columns will smartsheet add on your behalf when starting from a blank grid and enabling dependencies? what will smartshet do if a task is marked with elapsed time? SF FF SS Lead time lag time summary path driving path when a baseline is set what column is added to the grid? when should the project baseline be set? How can the “run now” option be accessed to test workflow automation? IF AND OR NESTING IF COUNTIF COUNTIFS Total Float() Sucessors() IsCritical()
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=<\/a><\/p>\n\n\n\n![\"Smartsheet](\"https:\/\/learnexams.com\/blog\/wp-content\/uploads\/2023\/12\/smartsheet-project-management-certification-exam-new-2023-2024-update-questions-and-verified-answers-100-correct-graded-a-725x1024.png\")
<\/a><\/figure>\n\n\n\n
In the settings tab under form submission select the reload the same form for another submission<\/p>\n\n\n\n
Set as default value<\/p>\n\n\n\n
you will loose metrics you may still want to track<\/p>\n\n\n\n
a sheet<\/p>\n\n\n\n
latest comment<\/p>\n\n\n\n
One the form, set the hidden and set the default value to “not started”<\/p>\n\n\n\n
Click forms on the menu bar, then click create forms.<\/p>\n\n\n\n
auto number<\/p>\n\n\n\n
select the row(s), then select the send option from the row menu.<\/p>\n\n\n\n
To share an item in workspace<\/p>\n\n\n\n
go to Gant View, click baseline icon in the tool bar, then click reset baseline dialog box.<\/p>\n\n\n\n
from the file menu select send as an attachment option.<\/p>\n\n\n\n
go to account settings, and click Group Management. Then click the pencil icon to add group members.<\/p>\n\n\n\n
click the publish icon on the right toolbar, click the slider for the desired publish option.<\/p>\n\n\n\n
click the paper clip icon in front of a row, or click the paper clip icon in the right feature bar<\/p>\n\n\n\n
go to the gant view and lick the baselines icon in the top toolbar<\/p>\n\n\n\n
3.5 d<\/p>\n\n\n\n
type 0 in the duration column<\/p>\n\n\n\n
when you plan to have two or more tasks start at the same time<\/p>\n\n\n\n
click the critical path icon in the top right of the sheet.<\/p>\n\n\n\n
FS<\/p>\n\n\n\n
It is a method of organising work in a project<\/p>\n\n\n\n
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<\/p>\n\n\n\n
when you plan to have two or more tasks finish at the same time<\/p>\n\n\n\n
to represent a period of inactivity between the predecessor and dependent tasks.<\/p>\n\n\n\n
to represent a period of overlap between the predecessor and the dependent.<\/p>\n\n\n\n
click the summary icon on the right feature bar.<\/p>\n\n\n\n
Creating metrics in the project sheet may cause data and formulas to be accidentally deleted or changed.<\/p>\n\n\n\n
It identifies whether a row is on the Critical Path.<\/p>\n\n\n\n
in the filter on the toolbar, under show rows that match, select “row” and is on Critical Path as conditions.<\/p>\n\n\n\n
TOTALFLOAT([Task Name]@row)<\/p>\n\n\n\n
COUNT(ANCESTORS([Value 1]@row)<\/p>\n\n\n\n
IF(AND([End Date]@row,TODAY(), NOT(Status@row=”Complete”)),1,0)<\/p>\n\n\n\n
JOIN(SUCCESSORS([Task Name]@row),”,”)<\/p>\n\n\n\n
After writing the formula, right-click the cell to open the call menu and select the convert to column formula option.<\/p>\n\n\n\n
Sheet summary report<\/p>\n\n\n\n
Rich text widget<\/p>\n\n\n\n
last widget editor<\/p>\n\n\n\n
available to anyone with the link<\/p>\n\n\n\n
Assigned To has any of Current User<\/p>\n\n\n\n
Owner or Admin<\/p>\n\n\n\n
in the save as new dialog, select sharing in the sharing options section.<\/p>\n\n\n\n
{{Task Name}}<\/p>\n\n\n\n
similar to a metric sheet and allows aggregation of the most important project data for each of the projects in our portfolio.<\/p>\n\n\n\n
creating a template folder that contains all assets needed to manage a project ad cam be duplicated for each new project<\/p>\n\n\n\n\n
-to create a work breakdown structure
-to complete a calculation<\/li>\n<\/ul>\n\n\n\n
Sheet summary<\/p>\n\n\n\n
-Predecessors
-Duration<\/p>\n\n\n\n
count every day as a working day<\/p>\n\n\n\n
SF is a relationship more of a work-back schedule. assumes a fixed end point or completion date (event planning)<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
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_<\/p>\n\n\n\n
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<\/p>\n\n\n\n
adds intentional time between tasks. the added time is a period of inactivity.<\/p>\n\n\n\n
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)<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
variance<\/p>\n\n\n\n
after task, dates, duration, and prececessros are established.<\/p>\n\n\n\n
3 dot menu of any workflow and it is easy way to test automation<\/p>\n\n\n\n
evaluates a logical expression and returns one value when true or another when false<\/p>\n\n\n\n
used within another function to return true if provided logical expressions are true<\/p>\n\n\n\n
used within another function to return true if at least one provided logical expression is true<\/p>\n\n\n\n
allow to perform calculations on values in multiple cells<\/p>\n\n\n\n
Counts the number of cells within a range that meet the given condition<\/p>\n\n\n\n
counts the number of times all given conditions in their respective ranges are met<\/p>\n\n\n\n\n
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.<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
returns true if the task in on the critical path<\/p>\n\n\n\n