Hi guys,
So I'm trying to come up with an easy way to track progress on certain items. I have 9 columns which indicate % complete,10,20,40,60,75,80,85,90 and 100 %. I have a huge list of items and I have been trying to add checkboxes for each % complete so when the user click it, another total complete column gets updated with that number. The catch is that it has to get updated with the latest checkbox checked. So if i 10% is checked for 1 item, the Total Complete column shows 10%, but if i go tomorrow and check the 20% complete checkbox, the Total Complete column shows 20%. Hopefully that isnt too vague. I appreciate the help.
Thanks
PS. Attached is a sample of what I want to create, but I am pretty sure that the formula is wrong.
Bookmarks