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.
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
