+ Reply to Thread
Results 1 to 1 of 1

Using checkboxes to track progress

  1. #1
    Registered User
    Join Date
    07-19-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Using checkboxes to track progress

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1