-
nested forumlas
Hello, I'm having trouble with my nested formula and activating the Red, Green, Gray, Yellow ball based on the % compelte column. =IF([% Complete] = IS BLANK, activate the RED ball =IF([% Complete] = less than 100%, activate the YELLOW ball =IF([% Complete] = 100% activate the GREEN ball =IF([% Complete] = 0% activate the…
-
Post Trial Review of Smartsheet as an IT Project Management solution
I've been assessing Smartsheet as a viable replacement for MS Project at our office over the last 30 days and I thought I'd share my finding with the Smartsheet community in case somebody else is also doing such a review. I'd also invite Smartsheet to respond to my observations if they feel I've misrepresented anything…
-
Resource Allocation
I don't know if I actually have an issue with the Allocation or if I just don't understand how it's supposed to work. I have a project list that has children. Each project has the same children (Planning, Design Acquisition, Design, Construction Acquisition, and Construction). The entire project and all phases of the…
-
Help! classify by date
Good night how can I sort the rows of a date column from my spreadsheet? I am using filters so I can't use the "classify rows" function. Is there any formula for columns to always be sorted by date order? thank you!
-
Milestone task child in a % complete parent roll up
I have a number of milestones (0 duration lines) in my projects. These represent decisions, meetings, inspections and deliveries. I also use % complete to communicate with our finance department, customers and project team members. These factors don't seem to play well with each other in the schedules I have set up so far.…
-
Calculating Days - Error if no date is entered
I have a column called "Closing Date". I also have a column that calculates the number of days until the closing date. It works great if I have entered the closing date. However, if we don't know the closing date yet and leave that column blank I then get an error in the column that is calculating the closing date. Anyway…
-
Counting Rows
I have a list of projects divided into sections. Each section can have projects that have sub projects. When I use this formula on a section header ="Current(" +COUNT(CHILDREN()) + ")" my result looks like this: Current (24). However, the count does not include the sub tasks. How can I write the formula so that it will…
-
Lookup returning no results
I am trying to have a LOOKUP formula return a result based on the status of a checkbox. I have tried to forms - one by having it look for "0" and one by creating a secondary column that reads the checkbox and returns a "Complete" or "Not Complete" status. Neither will return a result. I have attached a screenshot here…
-
How to calculate schedule % updates in Smartsheet
Hi, I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration. i added a column with percentage updates as per schedule however, these percentages do not roll up to the…
-
% of children
Hi, I want to calculate % of checked children in the sheet below, can anyone help me? https://app.smartsheet.com/b/publish?EQBCT=41482d287b58426b801642f8c4cd31f0 Niclas