Connecting data table to spreadsheet via formula

**rex28** · 05-07-2010, 04:00 PM

Hi, i am looking for a formula (if there is one) for a spreadsheet i have to create at work. it has a list of dates when an item is due (for this i have the formula) but i need to attach a table to elements on the spreadsheet. i need a formula that will calculate the % complete of a list of tasks..is this possible?

**day92** · 05-07-2010, 04:24 PM

Rex - it might help if you upload some sample data and your expected results so we can better attempt to assist you.

**rex28** · 05-07-2010, 04:54 PM

Thank you Day92....

this is a copy of my summary sheet for just one the car parks...i need to add a connected table...what i am trying to do is connect it to "maintenance and repair" for example "routine-monthly" is showing as overdue, but in the structural appraisal this information is from, there are more than one item involved in the "routine" check..for example...structural support check, lighting check, and so on. so although my status column shows overdue there may have been some work done already so i need a formula/formatted table to add a column to above spreadsheet showing that although overdue 30% or 50% of this section is actually completed and so on..