Populate a column based on another column with check box.
Any help would be greatly appreciated.
What we would like to have happen is when a check box in one of the four columns (NA, GSS Introduced, Customer Accepted, Customer Completed) is checked, it will populate a Completion field in the corresponding row.
If NA is checked then Completion = 1
If GSS introduced + Customer Accepted + Customer Completed is checked then Completion = 1
If GSS introduced + Customer Accepted is checked then Completion = .50
If GSS introduced is checked then Completion = .25
I'm thinking I need a formula to put in the completion column that will update based on one of the four combinations described above. Not sure what the formula should be or how to string it together. Thoughts?
Help Article Resources
Check out the Formula Handbook template!