Reports

Find
Hello everyone, I'm afraid this is a very basic question: How do I find the start/end date (or generally any other value from a row) of the main task in my sheet? By "main task" I mean the tasks that governs all others tasks, where ANCESTORS would equal zero, but that's not neccessarily in row 1. So far I have tried to use…
Automated Reporting
In our organisation we prepare a number of different reports to different levels within the organisation. A lot of this information can be duplicated across different groups and levels. I am wondering whether we could create a sheet to capture these reporting updates from teams, through direct entry into the sheet, or…
#DIVIDE BY ZERO
Hi, I have a Smartsheet with calculated columns like - =SUM(Open@row / SUM(Open@row:[Past Due]@row)) The Smartsheet is being used to create Donut graphs on a Project Dashboard. In the example above; Open = 0 In Progress = 0 Closed = 0 Past Due = 0 rather tan getting 0%for Open, I get #DIVIDE BY ZERO How do I resolve this?…
Is the report made from a sheet suppose to change as the sheet changes? Issue
Hi, In my sheet I have 137 rows, but in the report I made from the sheet I have 167 rows. Shouldn't both the sheet and the report have the 137 rows? Thank you
User Access Review and Approval
Hello, I am trying to create a workflow for role owners to review and approve their user access. Role Owners have multiple users- so I don't want to have an email go out for each user. Has anyone created a report like this?
Roll-up report with dynamic view?
I have a situation in which I’m going to have a team of people, each assigned a group of sheets/projects, and more sheets/projects will be added regularly. I need to be able to: a. Aggregate data from each person’s sheets so they and their managers can monitor progress; and b. Give the team a user-friendly way to keep the…
Removing Comments from a Published Report
Hi all, We would like to remove the comments from rows in a published report. I came across another post from August 2020 inquiring about the same thing. There was no feature to do so at the time. Has anything changed since? Thank you in advance.
Can we bulk export sheets to PDF that are part of a report?
This question stems from a previous topic. Given a report that pulls from 10 sheets (updated by different PM), can I bulk export all sheets to PDF so I can drop them in a Box folder for archiving with a weekly report summary?
How do I display a different symbol based on multiple values?
I've searched the community and tried multiple formulas but I cannot seem to get this scenario to work. I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display. Scenario: 0% = Green 1% - 10% = Yellow 11% and over = Red This is the formula I'm currently using. I get the Green…
Send report as attachment in Excel format without comments
Hi, I would like to send a report in Excel format, but do not want the comments to be visible to recipient. Currently they are on a separate tab. Rgds Warren

Reports

Discussion List