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
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!