Two part formula question.
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
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!