How to show a "Completion Status" column based off of certain cells containing value?
Hello Smartsheet community,
I have a database containing the amount of training specific employees have received. I would like to create a formula that is able to recognize what level someone is at and then the training needed for that level. If they have received the training it would show as "complete." If they have not received all of their training, it would show as "incomplete." Pictures below for detail:
This is the current sheet and how it looks:
I would like the "Completion Status" column to show that employee "Test 1" and "Test 3" are complete since they have received all trainings needed for the L1 level. I would like employees "Test 2" ", "Test 4" and "Test 5" to show as "incomplete" since they have not received all of their trainings.
Depending on the employee's level, the amount of training they receiving will be different. An L1 employee will receive 4 trainings to be fully complete, and L3 employee will receive 6 trainings to be fully complete.
Please let me know if you have any ideas on how to create this.
Help Article Resources
Check out the Formula Handbook template!