Formula To Add Columns that Contain a Value

Hey All,

I am creating a training matrix and need help with a formula for the "Total Trainings Completed" column. Each training (1,2,3,4, etc.) will be its own column and based on where the employee is at in the training a number value will be entered in that columns cell ( 0= not started, 1 = in process, 2= trained, 3 = seasoned, 4=trainer). I need the total trainings completed to count each column as a value of 1 if the value entered in the cell is >1. So for example I need Joe Smiths Total Trainings Completed to equal 2 ( 2 of the 4 trainings have been completed).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!