I am in construction and trying to create a new spreadsheet to track progress.
if you can see the example below I have a system that creates this report as employees click off on actions in internal system.
black means has been clicked complete, red means has not.
I have another sheet that has job numbers and other information
I have two cells that I want to look up information below.
find the job number from the first page(blue highlight)
find the last completed milestone date(orange highlight) this would be in one cell (column S starts line 9)
the other cell, would fill in the last completed milestone name. (green Highlighted) (column T starts line 9)
each week I would drop the spreadsheet in that is below and would update as progress occurs.
example. this week Column s would have 12/21/22, Column t would have "Drywall-sand/completed Drywall"
assuming things stay on track. and the date was 1/28/23. and I pulled the report.
Column S would now be 1/26/23 and T- would be Mechanical finishing....
look forward to anyhelp that can be provided!
if you can see the example below I have a system that creates this report as employees click off on actions in internal system.
black means has been clicked complete, red means has not.
I have another sheet that has job numbers and other information
I have two cells that I want to look up information below.
find the job number from the first page(blue highlight)
find the last completed milestone date(orange highlight) this would be in one cell (column S starts line 9)
the other cell, would fill in the last completed milestone name. (green Highlighted) (column T starts line 9)
each week I would drop the spreadsheet in that is below and would update as progress occurs.
example. this week Column s would have 12/21/22, Column t would have "Drywall-sand/completed Drywall"
assuming things stay on track. and the date was 1/28/23. and I pulled the report.
Column S would now be 1/26/23 and T- would be Mechanical finishing....
look forward to anyhelp that can be provided!