Sheet Summary Formula Help
Options
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)
 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.
 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.
 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
Answers

 I'm not sure I follow exactly what you are looking for.
 =IF([Completed Date]@row > [Due Date]@row, "At Risk")
 =IFERROR([TTL Shots in Project]@row / [Approved #/Complete]@row, 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!