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).
Answers

Hi @Biiams
You can use this formula in the Total Trainings Completed column
=COUNTIF([Training 1]@row:[Training 4]@row, >1)
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
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
Check out the Formula Handbook template!