I need help with formulas!
Hello, I am trying to create a dashboard for our staffing office and trying to create a visualization of how many of each discipline (RN, MHW) are assigned to each shift. I have a separate Metrics sheet where I have the total for each shift and the total for each Discipline; however, I cannot figure out the formula to calculate a total for each Discipline assigned to each Shift. I hope the screenshots help, and I greatly appreciate any feedback :)
Best Answer
-
Hi! Have you used the COUNTIFS function before?
COUNTIFS Function | Smartsheet Learning Center
I think this is what you want. Basically, instead of just giving the formula one range+criterion, you can give the formula multiple range+criterion pairs to look at. So for the first range+criterion pair you can use the exact same wording as your shift COUNTIF, but then for the next pair inside the COUNTIFS formula you enter the Discipline column & the Discipline value you want counted for that shift. Then the COUNTIFs formula should give you the total rows that meet both of those criteria.
Answers
-
Hi! Have you used the COUNTIFS function before?
COUNTIFS Function | Smartsheet Learning Center
I think this is what you want. Basically, instead of just giving the formula one range+criterion, you can give the formula multiple range+criterion pairs to look at. So for the first range+criterion pair you can use the exact same wording as your shift COUNTIF, but then for the next pair inside the COUNTIFS formula you enter the Discipline column & the Discipline value you want counted for that shift. Then the COUNTIFs formula should give you the total rows that meet both of those criteria.
-
Thank you very much, this worked! For reference, here is the formula I used:
=COUNTIFS({ReferenceColumn1}, "MHW", {ReferenceColumn2}, "3 - 11 PM to 7 AM")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!