Sheet Summary Formula Help

Tara Geraghty

Hi there, I'm needing some formula help as I'm not a formula wizzard but working on learning. I have a sheet for tracking images that are retouched on a weekly basis (see below). I've structured it to nest at a month level, week level then individual weekly projects (i.e. 0407fw13)

1. I would like to create a sheet summary that shows Current Week; % Complete, by searching start date/due date and reporting the % complete column for the total Wk/Job. Not sure if that is possible or if I need to go about it in a different way.
2. I also would like to add a column with the following rule. If Completed date is later than due date, flag with At Risk or other symbol/late notice.
3. If anyone knows how to make the #divided by zero formula = 100%, (which is just TTL Shots in Project/Approved # Complete using the percentage option) when each field is a ,that would be great as well but lower priority for now.

If anyone can provide formula suggestions for the above

Thanks!

tara

Paul Newcome

1. I'm not sure I follow exactly what you are looking for.
2. =IF([Completed Date]@row > [Due Date]@row, "At Risk")
3. =IFERROR([TTL Shots in Project]@row / [Approved #/Complete]@row, 1)