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)
- 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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!