-
Dashboard issues
Hi SS community…. One of the biggest pain points for my team and myself is the space that is wasted on dashboards. When You display reports and Dynamic calendars etc. and the lines reported in the widget do not fill the space at that moment it leaves a ridiculous amount of empty space which for a dashboard does not bode…
-
Report date a document was modified
I am trying to report via a summary sheet the date that the a sheet was updated. I am wanting to report when any row on the sheet was updated not just a specific line. I'm hoping that its something really simple that I've missed.
-
This is really a report question, I cannot use a date in the What section of building a report.
I am trying to build a report based on a date field. In the sheet, I can filter on and use the date field every way I need but when I try to build a report on the same sheet, that date field is not available when I come to the "What" filter of when building the report. I can literally see the field almost disappear in the…
-
Form Dropdown Help
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on each category (all numbers don't have to be used, but they can be). I want the form to…
-
Roll up of assessment data with conditions
I need to be able to roll up associated transmittal #s to 1 Transmittal and if the assessment status is Not Compliant for any of the Compliance Assessments then Transmittal 1 should equal Not Compliant, Transmittal 2 = Not Compliant, Transmittal 3= Compliant
-
How to link the health column to show an accurate status of at risk tasks.
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the…
-
Report on no activity
We have over 500 smart sheets for various processes. We'd like to know which smart sheets have had no activity for the day. Is there an way to create a report for this? Any ideas or suggestions would be highly appreciated.
-
How can I pull a report- or write a forumula to show me Rows with a specific status?
I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Status for EACH team member. My goal is to be able to facilitate compliance by providing…
-
Sheet Linking - Project sheets to single metrics sheet
Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and analysed. The information & metrics from all projects should be collected in the Metrics sheet.…
-
unable to select report data for chart
Hi, I have generated my report based on resources, accounts and project status which I am trying to create a chart for but it won't accept the data from the report - any ideas?