Sign in to join the conversation:
I have a dashboard that provides counts of certain data. One of the counts needs to be date-driven in the respect that it needs to show the count for the current year. How do I build that into the widget?
You'll need to start by creating that metric somewhere. In a new sheet you can use a cross-sheet formula to count all of the projects that are in your project sheet. I imagine you can do that by looking at the due-date.
The IFerror will count cells without dates or that are blank as 0.
The final formula should look something like this...
=COUNTIFS({Name of Cross Sheet refrerence}, IFERROR(YEAR(@cell), 0) = 2019)
Then in your metric widget. You will point to the sheet that you just created and include that metric. I like to use one cross sheet reference for most of my dashboard calculations. But occasionally, I have to use more than one if we are performing metrics on multiple sheets.
In my job as a scheduler a common question is "which of the predecessors for this activity is driving the date?" Currently I have to rely on my own knowledge of my schedules or, worst case, I have to look at every predecessor until I find the one I am looking for. Microsoft Project is nice because it has the "inspect"…
Hi! I am trying to create DVs from this sheet that will do the following: In this screenshot example - Elizabeth is the roadmap owner, but Deb is the Calendar invite owner. So in Elizabeth's DV, I still need her to be able to see this row, but not be able to edit the Calendar Update Complete column. In Deb's DV, I need her…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
