Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Making % Complete Column Accurately Reflect Work Done
I am looking for a way to make the % complete on my parent rows reflect only work that takes effort, rather than processes that are just elapsed time.
For background, my group uses smartsheet for project management purposes, but we also use it for billing. Our parent rows in our project sheets are all billing categories, for example, we charge $x for "Data Collection" and $y for "Data Analysis," but each is a long process with many steps, some of which take effort/resources/man-hours, and some of which are just elapsed time. At set times (ie quarterly) we check the % complete of the parent rows for our projects, and bill our clients for the percent of the total that is complete. So if I have an ongoing task that takes many days but no effort, it contributes disproportionately for the % complete, so it may say we are 20% complete when we have really done 70% of the work.
I know this may not seem like a serious problem but it would help our smartsheet meet multiple important needs for our group.
The elapsed time feature has been helpful but obviously does not fix this issue. It would be great if there is some way to designate a row so that it will not count for the total % complete calculation.