Day counts
Hello,
I am working on formulas to gather our end date/past end dates for example I want to capture 45-day, 30-day, 15-day, 10-day and 5-day I do not care if it is in a pie or metrics just not sure the best way to gather the data with there already being a formula in the column to calculate those days then present them on the dashboard.
=COUNTIFS([resource_on_active_project]:[resource_on_active_project], "Yes", [Days until/past end date]:[Days until/past end date], "-15")
I am receiving the "#Invalid Data Type"
Then for this formula =COUNTIF([Project End Date]:[Project End Date], I receive incorrect count.
Adriane
Best Answer
-
Figured it out:
Created a formula in the summary of the sheet, created a report, then created a pivot table to display my data.
Adriane
Answers
-
Update: stakeholders are looking for this type of output on a dashboard
Count of offboarded per Fiscal Year and Quarter based on each theater AMER, APJ and EMEA by our HR managers and our partner managers.
I am at this point drawing a blank.
Adriane
-
Figured it out:
Created a formula in the summary of the sheet, created a report, then created a pivot table to display my data.
Adriane
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!