-
Show top 10 schools on dashboard based on number of active students at each in datasheet
Been playing around for a while and haven't been able to sort....I have a datasheet with a bunch of data associated with a list of students, including the school they attend and whether they are currently active, graduated etc. I am looking to build a dashboard widget that shows the top X schools by count of active…
-
Gannt Chart in Dashboard
I have a dashboard that I've created that is pulling in a report that looks at key activities and dates from a project plan. It is a Gannt chart so users can get the visual of the project status. The problem I'm running into is that the Gantt chart is being displayed with the earliest date/data from the report. I scroll to…
-
Multi-Project Dashboards
I'm maintaining some multi-project dashboards and running into some problems with dynamic cells. Currently we have "Metrics" documents for each project. These documents contain cells that link to our timeline documents. For example: A cell may contain Phase I Health Status - and the cell value links to the Phase I health…
-
Variance on task list
I have a sheet that is a running list of tasks that gets added to weekly. I am looking to figure out how to show how early, or late, a task is completed in relation to the due date. If the task is on time, I want to show 0. I have been trying to use this formula =NETWORKDAYS([Due Date]@row, [Actual Finish]@row) - 1 This…
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…
-
Displaying parent rows only in a report
I would like to display the highlighted (yellow) information (parent rows) in a report only. The current report is pulling in both parent and children rows. I would like the report to display the conditional formatting from the sheet, as well.
-
Time Tracking
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% takes as long as the first 90% (or, unfortunately, more) People often think they're almost…
-
% Not showing on Report
I have a sheet that shows a number converted to % (i.e., 51%), but on the report it is displaying as 0.507 with no option to transform the number to percentage. What am I doing wrong?
-
Surface row report data to dashbord
Is there a way to surface a contact from a row report to a dashboard? When I go to add using a metric the row report is not accessible. I note that the row report is accessible to surface data for a chart. What am I missing/not doing?