Smartsheet Practice Questions with Verified Solutions

Smartsheet Practice Questions with Verified Solutions " =IF(([Estimated Completion Date]1 - [Date Need By]1) = 0, On Time, ([Estimated Completion Date]1 - [Date Need By]1)) Which section of the formula does Reginald need to correct? " The value if true A user opened a report that you shared to them but cannot see any data. Which is a reason that might occur? The user is not shared to any sheets that the report is pulling data from Alex is building a sheet to keep track of her tasks on a website project. She must perform the same set of tasks for each webpage. She listed each webpage on her sheet and has written out the tasks for the first one. What is the fastest way for her to add the tasks to the remaining webpages? Copy the rows with tasks, then paste them under each webpage Andy created a report for a member of his team, Bill, to see his tasks in one place. He now needs to create a similar report for another team member, Candace. What should Andy's first step be? Save Bill's report as a new report Bobbi has 3 sheets that she uses to manage different categories of purchase requests for her procurement team. The procurement director needs to see the combined value of approved requests across all categories. How can Bobbi display this value? Create a report to combine approved requests, then summarize the values using SUM Faisal is managing a project in a sheet. He has a symbol column to track tasks that are at risk. When a task becomes at risk, he wants to immediately notify the person assigned to the task. How could he do this? Create an alert to notify the assignee when a task is marked at risk Guillermo owns a project tracking sheet. His sheet uses a hierarchy with all tasks being children of a phase. He created a filter to help his team see only their tasks. They are reporting that it is difficult to understand the phase as there are tasks with the same name in multiple phases. To help them understand the phase, he has added a column titled "Phase." What function can he combine with JOIN() to show this information? ANCESTORS() How can a user modify a report to get different results? Change the filter criteria How can Pierre send his project teams a weekly email that shows them their tasks and reminds them to make updates if needed? Build a task list report and schedule it to send as an attachment weekly How can she ensure that each request will contain the cost center? Make the field required