-
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?
-
Any templates or sample of multiple project dashboards?
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to create capture a single project but I'm not finding a nice way to show multi-project…
-
How do I remove a row from a report?
bonsoir, ligne 7 ici ?
