Two part formula question.

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

  • Austin Smith
    Austin Smith ✭✭✭✭✭

    @Eric C

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!