I am trying to write a formula to Identify departments that have not reported
I am trying to write a formula that will display departments on a dashboard that have NOT updated a value at any given time.
Basically, in this Scenario, If the Stamping dept has nothing logged in labor hours, I want Stamping dept to populate in a Dashboard as "non report" of sorts.
I have tried using an =IF formula on another sheet to identify but keep getting errors. I am sure their is an easy way that I am overlooking.
Answers
-
Hi, Brian. You might use a report. Create a report based on your sheet. Select which columns you want to appear in the report, then apply a filter to the [Labor Hours] column that shows only those that are blank or zero. You can then add a Report widget to your dashboard that will display the report. What's nice about this is that it is dynamic. So, if changes are made to the sheet on which the report is based, your report will automatically update on your dashboard.
Here's more on reports if they are new to you: https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!