Two part formula question.
![Eric C](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Eric C
✭✭
I am trying to count the numbers of cells that have a checked box and have a date within two cells for a training tracking sheet. I am trying to track who has completed assigned training only. I don't want to count the date if it wasn't required. I would like to do it for each row (each employee) and for each column (each class).
Formula suggestions would be greatly appreciated.
Answers
-
Make the column a checkbox (can really do with any output) and try:
=if([bloodborne pathogens required]@row=1, if([bloodborne pathogens expiration]@row<Today(), 1, 0), 0)
Will tell you if they've completed a required training and if it's still in date, then you can do a count on checkboxes showing status per employee.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!