-
Counting checkboxes
Hello, I am counting the children of selected check boxes and then seting a ball color with formula bellow: =IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 2, "", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 1, "Red", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 0, "Green"))) This works fine but, when I have more than three checkboxes…
-
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
-
I'm looking for a way to calculate time of day based on predecessors.
I have a very specific need to a time intensive schedule that requires time of day (TOD) to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer these to be formula driven. Has anyone done this?
-
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…
