-
Can a dashboard be exported to a Google slide deck?
I would like to take parts of a dashboard and roll the data into a preestablish Slide deck
-
How to hide the item # column & reduce header size in a published report
In the below example, I have embedded a report widget (top) and a web content widget (bottom) in a dashboard. In a published web content widget, is there a way to hide the item/row # column, and a way to reduce the header size to appear similar to the report widget? Thanks.
-
Printing Reports
There seems to be a disconnect between what appears on the screen of a report vs what gets printed. Has anyone found a work around on this? Specifically, we are trying to keep the groupings to remain on the printed version but when we got to print, it removes all of the groupings and just lists the rows out. We did find a…
-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn to…
-
Reporting with on Sheets with Common Row Value
I love the functionality of creating roll-up reports that incorporate multiple sheets that have the same columns. What I can't figure out, and feel as though should be a possibility though is the ability to create a roll up report that combines sheets that have only ONE column in common. For example, let's say I am…
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and status…
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
How to count At Risk task to create a report?
Hi, I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how. I've used =SUMIF({Sheet - Request Tracker with Form Range 1}, "Red") =COUNTIF({Sheet - Request Tracker with Form Range 1}, "Flag") Thanks for your help
-
How to make a COUNTIFS Formula work
Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff would complete a form that asks for their name, contact details, job role and their…
-
Shared report not showing all sheets
Hi Everyone, I have an issue where I have a report that is combined from 9 individual engineer smartsheets. As the admin, I can see all 9 users sheets and the report looks correct. However, when I emailed the report to my other email address to check it, the report shows only my own rows (because I shared my own sheet with…
