How to get a value based on a series of dates?


I am trying to return the the number of highest level training completed. There is eight columns in my sheet for training completion date: "level 1 completion, level 2 completion, level 3 completion" etc. I made a column called "Training Level" and was hoping to get it to reflect the highest level of training completed based on the dates entered but not even sure where to start.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!