Core Product Certification Practice Exam
Aly wants her entire department to be able to view multiple reports every week. There are a few associates on Aly's team who don't have access to Smartsheet. What is the recommended action Aly should take? A: Send the reports as an attachment with a weekly recurrence B: Grant everyone on the team Viewer access to the reports in Smartsheet C: Select the rows to send to the recipients with a read-only version of the data D: Send an update request to all team members
A: Send the reports as an attachment with a weekly recurrence Reports can be sent to any email address as an attachment on a weekly or monthly basis without having to give anyone access to the report itself.
Mark has a project plan with multiple vendors, but he has not shared all his vendors to his sheet. He wants to set up an automation to request weekly updates from all of his vendors. How should Mark set up the permissions for the automation? A: Set the permission level to Unrestricted B: Contact his system administrator to set the correct permission level C: Set the permission level to Limited D: Set the permission level to Restricted
A: Set the permission level to Unrestricted Mark should make sure his workflows are unrestricted so any email referenced in the workflow can receive the automations.
Bridget would like to group the tasks in her report based on the Assigned To column, but that column is not shown as an option in the Group by dropdown list. What is the most likely reason for this? A: Bridget has more than 1,000 rows in the source sheet B: The Assigned To column is a multi select contact column. C: There are no names yet in the Assigned To column D: Bridget is an Editor on the source sheet.
B: The Assigned To column is a multi select contact column. Multi select columns cannot be used for grouping in reports.
Alex uses a report to track the status of all of her projects in progress. She wants data for all projects, including new projects, to populate in this report. How should Alex set up the report to ensure it is always up to date? A: Create a metrics sheet B: Use a folder as the source C: Create a Sheet Summary report D: Use a workspace as the source
D: Use a workspace as the source Selecting a workspace as the source for the report ensures that any new project sheets added to the workspace are reflected in the report output, eliminating the need for manual updates.
Rachel is building a new project plan. She has opened up the Gantt view project settings and checked Dependencies Enabled. What 2 columns will be automatically added to her project plan? A: Predecessor and Duration B: Assigned To and Status C: Start Date and End Date D: % Complete and Primary Column
A: Predecessor and Duration Enabling dependencies in a sheet is a way of visualizing the order of events in a project. The Predecessor column allows the user to select the row(s) which the current row's start date depends on. The Duration column shows how long each row is scheduled to take based on the Start and End Date columns.
Taryn created a report to view the tasks she's assigned to across multiple project plans. However, she cannot see which projects or phases the tasks are associated with. Taryn wants to add a column to the sheets with a formula that automatically displays the project name and phase name next to each task, then add that column to her report. What formula should Taryn use? A: =JOIN(PARENT([Task Name]@row), " - ") B: =PARENT([Task Name]@row) C: =ANCESTORS([Task Name]@row) D: =JOIN(ANCESTORS([Task Name]@row), " - ")
A: =JOIN(PARENT([Task Name]@row), " - ") The ANCESTORS() function returns an array of all ancestor rows of the current task row, which would include both the project name and the phase name if they are organized hierarchically above the task. The JOIN() function then concatenates these ancestor values into a single string, separated by " - ". This provides a complete reference to the project and phase for each task.
Patty manages 3 sheets that different departments use to submit requests. She wants to give sheet collaborators access to the number and types of requests that get submitted to each sheet, as well as roll up these metrics across all3 sheets to display on a dashboard. What is the most efficient way for Patty to track these metrics? A: Create Sheet Summaries on each sheet and a Sheet Summary report B: Add additional rows at the top of each sheet to track the metrics C: Create grouped and summarized row reports for each sheet D: Create a separate Metric sheet
A: Create Sheet Summaries on each sheet and a Sheet Summary report Tracking metrics in the Sheet Summary fields of each sheet allows collaborators to easily access this data in one place. Also, Patty can copy the formulas she creates to track the number and type of requests from one Sheet Summary to the other 2 sheets. Creating a Sheet Summary report allows the comparison of metrics between the sheets and the creation of a dashboard chart.
Thomas has a project plan with multiple vendors, but he has not shared his sheet to all his vendors, as some of them arecompetitors to one another. Now he wants to request a one-time update request from a particular vendor. What is the most efficient way for Thomas to request the information? A: Create a manual update request for the specific row B: Publish the sheet with the option Edit by Anyone C: Create an Automated workflow D: Send the sheet as an attachment and ask for the required information
A: Create a manual update request for the specific row Thomas should use a manual row update request in this situation so he can request the update only from the needed vendor(s) and because this is most efficient for a one-time update, rather than a recurring automation.
Amanda is creating a dashboard for her director to show the percent completion of several marketing campaigns in progress. She wants to summarize metrics from multiple tracking sheets on the dashboard. How can Amanda accomplish this? A: Create a metrics report based on the tracking sheets and add it to the dashboard using a report widget B: Use a chart widget on the dashboard to summarize the data from the tracking sheets C: Use a metric widget on the dashboard to summarize the data from the tracking sheets D: Create links to the tracking sheets on the dashboard using a shortcut widget
A: Create a metrics report based on the tracking sheets and add it to the dashboard using a report widget Widgets can generally only pull data from one source sheet or report. Amanda can create a metrics report summarizing the data from her tracking sheets and share the report directly on the dashboard using a report widget. She could also summarize the data from this metrics report using a chart widget.
Ken is building an event schedule. He would like everyone to simultaneously see the whole schedule at one time but also allow each team member to focus on their own tasks immediately. Which is the most efficient way to accomplish this? A: Create conditional formatting to assign a color to each team member B: Create a Current User filter C: Manually assign task bar colors in Gantt view for each team member D: Write a formula that shows overdue tasks
A: Create conditional formatting to assign a color to each team member If the sheet has an Assigned To column that lists which team member has been assigned to each task, Ken can use conditional formatting to associate each teammate's name to a color. This way each teammate can see the whole schedule while only focusing on their assigned color.
Bruna is managing a request process and uses a form to collect request information. The user must log into their Smartsheet account in order to access the form. To save users' time, Bruna wants to avoid requiring them to manually enter their email address. What column type should Bruna use to capture this data? A: Created by B: Modified by C: Contact list D: Dropdown list
A: Created by The Created by system column will automatically display the email address for who created each row (i.e., who submitted the form).
Alex is a project manager working on the launch of a new product. Annie, the designer, was just made aware of an unforeseen delay with the product's packaging design, which will delay the timeline of the entire project. She wants to leave a comment for Alex so he is immediately notified this task will be delayed. What is the most efficient way for Annie to ensure that Alex receives the notification of her new comment promptly? A: In the far left column of the task row, select Add a comment. Mention Alex in the comment using the @ symbol. B: Open the Conversations tab and type a comment. Then click the menu and select Email Comment to send an email to Alex. C: Open the Conversations tab and leave a comment. D: Comment directly on the task row of the delayed task.
A: In the far left column of the task row, select Add a comment. Mention Alex in the comment using the @ symbol. By using the @ mention, Alex will instantly receive a notification with a link to the specific task row comment on the sheet.
Michael is publishing a report to share with his team about a project that contains sensitive data that he doesn't want people outside his organization to see. Michael's team does not have access to the underlying sheets for the report. What Access Control setting should Michael use when publishing this report? A: Only available to users in the owner's plan B: Available to anyone with the link C: Only available to users who are shared to the item D: Read Only - Full
A: Only available to users in the owner's plan This Access Control setting creates a secure link that requires the user to log into Smartsheet before being able to view the content of the link. Only users who are added to Michael's Smartsheet plan will be able to view the content, and because the report is published, they will be able to view it even if they haven't been shared to the underlying sheets.
Amy is a project manager who is looking at a report of the current status for all of her department's project schedules. She wants to update the projected completion date in the report for one of the projects but she is unable to edit that field in the report. What would cause Amy to be unable to edit the date in the report? A: The end dates in the underlying sheets are based on dependencies B: The underlying sheets contain row hierarchies. C: Amy has Editor permissions on the underlying sheets. D: The underlying sheets contain conditional formatting
A: The end dates in the underlying sheets are based on dependencies If dependencies are enabled in a sheet, users have to manually update the start date or duration in the sheet. It is not possible to update the end date in a sheet or report built on dependencies.
Damian has a dashboard tracking the status of several open IT tickets. He wants to display the status of these tickets on a screen in the office so that his department can view their workload in real time. How can Damian accomplish this? A: Turn on Auto-Refresh and display the dashboard in presentation mode B: Copy the metric widgets into a slide presentation C: Export the dashboard as a PDF D: Share the dashboard to the team with Viewer permissions
A: Turn on Auto-Refresh and display the dashboard in presentation mode Turning on Auto-Refresh will ensure the display gets updated at specific intervals. Displaying the dashboard in presentation mode ensures an optimized viewing experience for the department
Celina is looking to lock in a column value in the following formula, so that she could apply the formula to any row and itwould still reference the same column: =IF([%Complete]@row=1, "Green", "Yellow") What should Celina add to the formula? A: =IF([%Complete]$@row=1, "Green", "Yellow") B: =IF($[%Complete]@row=1, "Green", "Yellow") C: =IF([%Complete]@row$=1, "Green", "Yellow") D: =IF([%Complete]@row=1:[%Complete]@row=.5, "Green", "Yellow")
B: =IF($[%Complete]@row=1, "Green", "Yellow") The $ is an absolute reference. In this case, the absolute reference should appear before the column %Complete, which will tell the formula to always reference the %Complete column regardless of the cell the formula is in.
Keegan created a project plan that nests individual tasks within larger project phases. On Keegan's project plan, he has recorded the estimated hours each task will take to complete in the Estimated Hours column. He wants to automatically display the sum of the estimated hours for each phase of the project in the same column. What formula should Keegan use to summarize the total estimated hours for each parent row in his project plan? A: =AVG(CHILDREN()) B: =SUM(CHILDREN()) C: =SUM(PARENT()) D: =ADD(CHILDREN())
B: =SUM(CHILDREN()) The SUM(CHILDREN()) function is used to calculate the total sum of values from child rows beneath a parent row within a hierarchical structure.
Alison has added new chart widgets to a previously published dashboard during a status meeting with a client. The client says that they're not seeing the new charts at the published link. What action should Alison take? A: Save the underlying sheets and reports for the dashboard B: Ask the client to check again in 10 minutes C: Republish the dashboard D: Update the Access Control settings
B: Ask the client to check again in 10 minutes The default Auto-refresh setting for published dashboards is to automatically update every 10 minutes. This can be changed in the View menu > Auto-refresh.
Fasiya created a feedback form to include on her small business's website. She has a Status column in her sheet for her to track whether feedback has been implemented or addressed, and she wants the Status of all new submissions to be Received. What is the recommended action Fasiya should take when setting up the form? A: Remove the Status field from the form and manually select the Received value for each new submission B: Assign the Status field a default value of Received and hide the field on the form C: Make the Status field required and include help text instructing customers to select Received D: Move the Status field to the bottom of the form and assign a default value of Received
B: Assign the Status field a default value of Received and hide the field on the form This will ensure that customers cannot see or change the Status column for their submission, and it also ensures that the default status for each new entry will be Received.
Benjy wants his associates to be able to update the status of their tasks on a report he has built. He also wants this updated information to appear on the underlying sheets. What does Benjy need to do to ensure his associates can update both the report and the underlying sheets? A: Create a Current User filter in the report for each associate B: Grant all associates Editor or higher permissions on the report and the underlying sheets C: Create a Sheet Summary report for all the underlying sheets and share all associates to it D: Grant all associates Admin or higher permissions on the report and underlying sheets
B: Grant all associates Editor or higher permissions on the report and the underlying sheets Users must have at least Editor permissions on both the report and the source sheet(s) to edit info in a report, which will then populate back to the source sheets.
Priya is calculating profits for her small business. In her tracking sheet for sales, she uses this formula to calculate the profit for each sale: =[Quoted Amount]@row - [Actual Cost]@row She wants to ensure that all future sales apply this formula automatically. What is the most efficient way for her to accomplish this? A: Create a conditional formatting rule B: Make the formula a column formula C: Copy the previous row and update the data for each new sale D: Create an automation
B: Make the formula a column formula To ensure any new rows added to the sheet have this formula applied, Priya should right-click a cell containing this formula, then choose Convert to Column Formula from the menu options.
The marketing team at Ajax Systems is organizing a product launch event. A new flyer has been designed to promote the event. The marketing manager has asked the graphic designer to attach the flyer to the "Review flyer" task on the event planning sheet. What is the most efficient way for the graphic designer to attach the flyer to the specified task? A: Navigate to the Attachments icon on the feature bar and click Sheet. Then attach the flyer. B: Navigate to the specific task's row on the event planning sheet, click on the Attachments icon, and upload the flyer C: Navigate to the Conversations icon on the feature bar, click the attachment icon, and upload the flyer. D: Navigate to the Attachments icon on the feature bar and click Row. Then attach the flyer.
B: Navigate to the specific task's row on the event planning sheet, click on the Attachments icon, and upload the flyer By navigating to the appropriate row and uploading via the Attachments icon, the graphic designer can ensure that the document is attached to the specified task.
Liqiu is creating an automated alert to notify members of the IT department when a new ticket has been assigned to them on the tracking sheet. She also wants to send an alert to the manager if a new ticket has been added but not assigned. The sheet tracks the following columns: Ticket Number, Status, and Assigned To. What is the minimum number of automated workflows Liqiu needs to create to send these alerts? A: Two B: One C: Three D: Four
B: One Liqiu can send the alerts with one automation using condition paths. She should choose the trigger When rows are added or changed. Under the Trigger, she should specify that this workflow should run when Ticket Number > changes to > Any Value OR when Assigned To > changes to > Any Value. Then, she can create a condition block with 2 conditions: where Status > is one of > Not Started and where Assigned To > is not blank. This condition block should trigger the action Alert someone > Send to contacts in a cell, and she can select the Assigned To column. Next to the first condition block, she should select Otherwise to trigger an alert action when the Assigned To column is blank. In this action, she can choose Alert someone > Send to specific people, and enter the manager as the contact.
Andreas is creating a sheet to keep track of listings for his real estate company. He wants to include a photo of each house in the sheet, and he wants to ensure that the images are accessible by using alt text to describe the contents of the photo. How can Andreas add alt text to his images? A: Add a separate column to enter the image description in the same row as the photo B: Type the image description into the cell before inserting the image into the cell C: Enter the image description in a row comment D: Paste the image into the cell and the sheet will automatically generate the alt text
B: Type the image description into the cell before inserting the image into the cell Any text previously entered in the cell will become alt text after the image is inserted into the cell.
Xiao is trying to create a metrics sheet that will calculate the health of all the current ongoing campaigns in her marketing portfolio. She has a Health column in each campaign's sheet and is using the Symbol column type to indicate red, yellow, or green for the health status. Which of the following formulas should Xiao use in her metrics sheet to calculate how many campaigns have a health status of red? A: =COUNTIF({Portfolio Summary Rollup Sheet Range 1}, "red") B: =COUNTIF(Portfolio Summary Rollup Sheet Range 1, "Red") C: =COUNTIF({Portfolio Summary Rollup Sheet Range 1}, "Red") D: =COUNTIF({Portfolio Summary Rollup Sheet Range 1}, {red})
C: =COUNTIF({Portfolio Summary Rollup Sheet Range 1}, "Red") This formula uses the COUNTIF function to count the number of campaigns with a health status of red in a particular portfolio. Formulas that are looking at the Symbol column type, such as the Health column in this scenario, require each symbol's color to be capitalized.
Itzel is managing the schedule for a project. Her project plan consists of a hierarchy of project phases with tasks nested beneath them. She created a report that shows what tasks are due in the next 30 days. On this report, she cannot see which phase these tasks pertain to. How can Itzel see the phase in the task report? A: Create separate reports for the tasks in each phase B: Color-code each task to differentiate between different phases C: Create a helper column using a PARENT() formula that will pull the phase for each task into the report D: Add the End Date column to the report
C: Create a helper column using a PARENT() formula that will pull the phase for each task into the report Creating a helper column that references the parent row (phase) for each task will provide the necessary context within the report. This approach ensures that Itzel can see both the tasks and their associated phases, making it easier to manage and track progress.
Michelle is creating a workspace for a new project for her team. Her team consists of 3 project managers and her director. The project managers need to be able to edit and share all items in the workspace, but the director only needs to view the project plan and nothing else. What is the most efficient way to provide the project managers and the director with the appropriate permission levels? A: In the project plan, click on File > Share. Invite the project managers and director and assign the appropriate permissions. B: Navigate to the workspace and assign the project managers Editor - can share permissions. Then, navigate to the project plan sheet and assign Viewer permissions to the director. C: In the project plan, click on the share button. Share the workspace to the project managers with Editor - can share permissions. Then, share the sheet to the director with Viewer permissions.
C: In the project plan, click on the share button. Share the workspace to the project managers with Editor - can share permissions. Then, share the sheet to the director with Viewer permissions. Michelle can assign permissions to both the entire workspace and the individual sheet directly from the project plan sheet
Martha is an administrative clerk at Ajax Systems. She manages a sheet tracking purchase requests. Each purchase request lives on its own row and a Purchase Order must be attached as documentation. Smartsheet is not allowing her to attach 150 purchase order documents to her sheet at once. What is the most likely reason for this? A: Martha must upload each purchase order separately. B: Martha has reached the allowed maximum file size upload. C: Martha has surpassed the quantity of files that can be uploaded at once. D: Martha has reached the limit of attachments allowed on a sheet.
C: Martha has surpassed the quantity of files that can be uploaded at once. The maximum upload quantity is 100 files at a time.
Sean is a program manager and oversees a multitude of projects across 2 teams. Each project has its own sheet and the sheets are organized in separate folders based on the team lead, either "Team Arman Projects" or "Team Christine Projects." New project sheets will be added to these folders over time. Sean wants to build a report that allows him to see the statuses of all current and future projects across both teams. What is the recommended way for him to accomplish this? A: Select both folders as the source of the report B: Select the template sheets as the source of the report C: Organize both folders in one workspace and select the workspace as the source of the report D: Select all sheets within each folder as the source of the report
C: Organize both folders in one workspace and select the workspace as the source of the report Selecting a workspace will dynamically ensure that any new sheets added to the workspace will be reflected in the report output, eliminating the need for manual updates.
John is a paid user on a Smartsheet account. He is attempting to upload a 300 MB PDF file to his project plan in Smartsheet. However, when uploading the file he receives an error. Why is he unable to attach the file? A: John must be a system administrator for his account in order to upload files of that size. B: John is attempting to attach it at the row level, but he must attach the file at the sheet level. C: The file exceeds the allowable size for attachments for paid users. D: PDF files are not supported
C: The file exceeds the allowable size for attachments for paid users. The maximum file size limit for attachments in Smartsheet is 250 MB for paid users.
Juan is looking to automate the symbols that are produced in his Health column. He applies a nested IF formula, but the formula is returning an #UNPARSEABLE response. What is most likely the cause of the error message? A: The formula is in a specific type of column (Date, Number, Symbol) and the returned value is of a different type B: The formula attempted to divide an amount by zero. C: The formula contains a misspelling, uses the wrong case for column names, or misapplies quotation marks D: The formula references a cell that doesn't exist, possibly due to a row/column deletion
C: The formula contains a misspelling, uses the wrong case for column names, or misapplies quotation marks An #UNPARSEABLE error is displayed when the formula has a problem which prevents it from being parsed and interpreted. This can happen for many reasons, such as misspelling, incomplete operators, using the wrong case for a column name, or using single quotes instead of double quotes.
Benjamin is creating an IF formula to display specific Health symbols based on conditions in his sheet. When a task has a value of 100% in the % Complete column, he wants to show the green symbol. He is sure he typed in the correct formula but gets an #UNPARSEABLE error message. What is the most likely cause for the error message? A: The % Complete column is locked. B: The Health column is a symbol column, which does not allow formulas. C: The Health column is locked. D: The cell reference of the % Complete in the formula does not have square brackets.
D: The cell reference of the % Complete in the formula does not have square brackets. All cell references in formulas must have square brackets if the column name consists of more than 1 word or includes special characters.
Carson is creating a form to collect requests for IT equipment and software support from employees at their organization. The source sheet has the following columns: Request Type, Equipment, Date Needed, Software, and Issue. If an employee selects IT Equipment from the Request Type field, they need to submit answers for the Equipment and Date Needed columns. If they select IT Software Support from the Request Type field, they need to submit answers for the Software and Issue fields. What is the recommended way for Carson to set up their form to ensure they collect the responses they need? A: Add form logic to the Software field B: Add form logic to the Equipment field C: Add form logic to the Issue field D: Add form logic to the Request Type field
D: Add form logic to the Request Type field Carson should add two rules to the logic for the Request Type field: When > Request Type > is > IT Equipment, then show the following fields > Equipment and Date Needed. When > Request Type > is > IT Software Support, then show the following fields > Software and Issue. With these rules in place, employees who select IT Equipment will only see the Equipment and Date Needed fields on the form, and employees who select IT Software Support will only see the Software and Issue fields.
Annabelle is creating a form to collect campaign requests for the Marketing department. Requestors can select a Social Media, Traditional Media, or Email marketing campaign from the Request Type field. Annabelle knows that the vast majority of requests will be for social media campaigns. What is the most efficient way for Annabelle to set up her form to make it easier to request social media marketing campaigns? A: Hide the Request Type field and assign a default value of Social Media B: Create separate forms for each type of marketing request C: Make the Request Type field required D: Assign a default value of Social Media to the Request Type field
D: Assign a default value of Social Media to the Request Type field Assigning Social Media as a default value in the Request Type field will auto-populate this response on the form for all respondents. Requestors can change the Request Type if needed, but this will make it more efficient for those requesting a social media marketing campaign.
Mary is setting up a project schedule with predecessors and has created an Overdue column with a formula that calculates how many days a task is overdue. Now she wants to visualize the severity of the delay, depending on how many days a task is overdue. What is the most efficient way to accomplish this? A: Create a separate report for different ranges of days that tasks are overdue B: Sort the sheet based on the Overdue column C: Manually change the background color for each overdue task daily D: Create conditional formatting rules that assign a color to a row based on how many days a task is overdue
D: Create conditional formatting rules that assign a color to a row based on how many days a task is overdue Creating conditional formatting rules allows Mary to assign a different color for different ranges of days that each task is overdue.
Danai has multiple workflows to alert the Marketing team about changes to their projects. She is currently making changes to the layout of the project tracking sheet, and she doesn't want to trigger any of the automations and send unnecessary alerts to her team. While some minor changes may be necessary to the workflows after she is done editing the sheet, she intends to continue using the original automations once her edits are made. What is the recommended action Danai should take? A: Edit the triggers for the workflows B: Unsubscribe from all of the workflows C: Delete the workflows D: Deactivate the workflows
D: Deactivate the workflows Danai can select Deactivate from the menu in the top right of each workflow to temporarily turn off the automation. When she is done editing the sheet, she can reactivate each workflow
Siobhan is an event manager for Peak Performance Partners and is planning their annual event, Peak Leadership Summit. To prepare for this event, Siobhan is using a tracking sheet for all registrations and is creating a registration form for attendees. She wants the form to reflect the branding of the event to maintain a consistent and professional look. What steps should Siobhan follow to customize the branding on the registration form? A: In the form editor, right click in the background space to modify the color of the form. B: On the sheet, select the File menu, then select Properties, and set the theme colors to match the event branding colors. C: In the form editor's settings tab, edit the layout to a side-by-side format. D: In the form editor, click on the paint bucket icon to set the theme colors to match the event branding colors.
D: In the form editor, click on the paint bucket icon to set the theme colors to match the event branding colors. Clicking on the paint bucket icon when modifying a form will allow the user to set a custom color theme and/or background photo on the form.
Karim is trying to add a high-definition image to a cell, but he is unable to insert the image into the sheet. What would prevent Karim from including this image in the cell? A: It is a JPG file. B: It is 100 pixels in height. C: It is a PNG file. D: It is over 30 MB.
D: It is over 30 MB. The maximum file size for images is 30 MB.
Caroline has a set of tasks that are due in May, June, and July. She has the due dates written in a Date column, but she wants a separate column that displays what month the task is due in text form. She writes this formula: =IF(MONTH(Date@row) = 5, "May"; IF(MONTH(Date@row) = 6, "June"; IF(MONTH(Date@row) = 7, "July"))) However, this formula results in an #UNPARSEABLE error. What should Caroline do to fi x the formula? A: Add quotation marks around the numbers that depict the months B: Remove the quotation marks around the text that depicts the months C: Add an additional closing parenthesis at the end of the formula D: Replace the semicolons (;) with commas (,)
D: Replace the semicolons (;) with commas (,) The formula uses semicolons (;) instead of commas (,), which is the required argument separator in Smartsheet. By replacing the semicolons with commas, the formula will be correctly parsed and executed, displaying the correct month in text form based on the due date.
Danielle would like to have her entire department review a report weekly. Additionally, even though there are a few associates who don't have access to Smartsheet, Danielle wants to ensure that everyone has access to an up-to-date version of the report at any time. What is the recommended action for Danielle to take? A: Grant everyone Editor access to the report in Smartsheet B: Send everyone a published link to the report C: Select the rows to send to the recipients with a read-only version of the data D: Send the report as an attachment as a weekly recurrence and include the published link in the body of the message
D: Send the report as an attachment as a weekly recurrence and include the published link in the body of the message Reports can be sent to any email address as an attachment on a weekly basis without having to give anyone access to the report itself. Publishing the report and including the link in the body of the weekly notification allows anyone to access the up-to-date-version of the report at any time.
