-
Expand Global Updates & Programs Report Scope to add New Sheets to Archived project folders
Our company is adding new sheets to project folders, and some of them need to be in our archived project folders as well so that we can draw from our project history. Right now Global Updates does not support adding New Templates to Archived project folders. I can manually create sheets from the Toolkit Template, so there…
-
Show tasks that are happening today in a report
Hey! So, I'm on a construction company, and I need to make a report that shows the tasks happening today But I don't know how to show tasks that are not starting or finishing today, but are still in the process of completion. With these filters, if a task started yesterday and is finishing tomorrow, it will not show on…
-
Removing Total Row from Smartsheet Reports
I am creating several reports that subtotal financial information by various groups (i.e. revenue, numerous expense categories, EBIT etc.). I do not want the reports to display a total row that sums all the revenue, expenses, and profit as this is misleading. Does the functionality exist to turn this off?
-
Report for yesterday
Hello, I hope someone can help me. Maybe I'm blind, but I can't find a way to make a Report for only yesterday, I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum]. Now I want to make a report, that shows only the rows from yesterday. Not today, not further in the past. I want to…
-
Report Sorting
I feel like this should be simple, and it's not. I am trying to sort these rows by the month in this report. It was originally sorting alphabetically, so I added the numbers in front, and that didn't change it either. Any help? Thanks!
-
Dashboard > Report Widget | Empty filters are not not being mapped, data source not kept
When creating a Report widget with a filter not matching any results, the data source is not being kept. It will show this screen (see below) : With the details pane like this: Take note that I already mapped it to the correct report and still showing like this after saving. Issue here is when a filter matches the report…
-
Can you edit a report without editing the source sheet?
Can you edit a report without editing the source sheet i.e. conditional formatting, adding columns, locking fields, and field specific notifications.
-
Adding Current Month Data To Dashboard and Metric Widgets
Hello Community, 1st Question: I am creating a dashboard for our compliance statistics. I have built out a dashboard calculation sheet based off other sheets as seen in the image below. I am looking to add only the current months lable and associated data to my dashboard to keep it clean. 2nd Question: I also have the…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns a number that I would expect. The challenge is that when I create a row summary report that references the field Overdue…