-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Security concerns with published links
We have enabled the link public publish for our organization's users; however we want to purge or expire these public links after the need is over; because we are sure most users won't remember to toggle the public link off on the sheets or reports. I know there is a report that admins can generate that shows all published…
-
IDEA: Create Cross-sheet references from reports
Just want to throw this out there. I am referencing three rather large sheets and trying to bring in some COUNTIF data but keep getting told that I am referencing too many cells. This is prohibiting me from creating the data I need. It would be great if you could do cross-sheet references from reports. This would allow me…
-
Dashboard Viewing - Send as PDF
There are options to send sheets and reports on a recurring basis, but there is currently NO way to send a Dashboard as an email attachment on a recurring basis. The dashboard link is difficult to view on an ipad or mobile device. We would love to see the option to send a dashboard as a pdf or png attachment to an email on…
-
Renaming Reports - updateReport() functionality
There has been very little discussion on this topic. What is required to get this feature added to the API? I have been assigned the task of creating a JAVA app that will create new workspacea from a set of templates we've created. This is to be done through the JAVA API(SDK). I've completed the app other than renaming the…
-
Relational database / multiple values on sheet 2 linked to sheet 1
Hi Is it possible (and if not could it be?) to edit the value in a cell of a column that does not appear on the original sheet where a line in a report is pulled from? In other words, I'd like to emulate a 'relational' database. The use case is that we'd like to log results, measured using a series of indicators, of…
-
V-axis showing 0 and 1 instead of %
In my chart, I am displaying %, and the chart is showing that in Series -> Data Labels, but the vertical axis is showing only "0" and "1". I would like the vertical axis to show the values given, those between 0 and 1, as a %. Your help is appreciated. Thank you.
-
Do Not Include Comments in Export
I need to schedule an Excel file to auto send from a report to a client, but I do not want the Comments tab to be included. Is there a way around this? thanks,
-
Prevent column name from showing up in Sight
Hi, Has anyone found a way (or is there a way) to prevent a column name from showing up in a Sight? For example, I have a report on my Sight and a row in the report is actually the column name which is different than the Smartsheet column name (Smartsheet column name is "First Name" but the row showing the name is only…
-
Count only outstanding items
I have a Request Management sheet with a Form that we used to track tasks. They template came with a Metric sheet that is very useful. One of the metrics on this Metrics sheets counts items by assigned person. I want to update that to count only items that are not Closed status. Current formula is: =COUNTIF({Request…