Sheet Summary Formula Help

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


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!