-
Is there a formula to count how many times todays date is entered into a sheet?
-
Overdue Tasks Metric
I have an individual task report set up for everyone in the company which aggregate tasks from our project sheets. Then, we have an overdue task report that displays all overdue tasks for everyone, grouped by the assigned-to column. We have a summary field on the overdue report counting everyone's current tally of overdue…
-
Dashboard Metric Widget - Can you add a total from a sheet on the title?
Hello everyone, I am trying to see if its possible on the the widget to add a SUM from a sheet to the dashboard to be able to see the over SQM of a component of a project. I didnt want to add a line at the bottom of the displaying graph , wanted to show up top , is that possible or not?
-
3D Bubble Chart in SmartSheets
Hi Team, I am looking to recreate this 3D Bubble Chart in SmartSheets. Is this feature available? I would need the option to plot 3 variables. Please advise. X = Benefit Y = Effort Z = Size of the bubble Regards Sowmya
-
Reporting on top parent rows only, not all rows with children
Hi all, I have my projects set up as workstreams rather than phases, with a helper column for phases. I want to add a dashboard widget that lists out each workstream and its % done . In my hunt through the questions I found that I can add a helper column to indicate if a task has children like this: =IF(COUNT(CHILDREN()) >…
-
Dashboard widget - Can I set which rows are displayed?
I have a dashboard that is used for monthly reporting, part of the dashboard links to the project plan. When you open the dashboard this always shows the top few rows of the plan. As the project is now advanced these rows have long since been completed - Can I set the widget to display the currently active tasks at first…
