-
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
-
Countif Tasks are completed late?
Hey There~ I'm trying to count how many of my tasks are being completed late and I'm struggling to do this. Here's what I got: Here is the formula: =COUNTIF([Completion Dates]:[Completion Dates], >[Due Dates]:[Due Dates]) This returns zero but I want it to return three. However, =COUNTIF([Completion Dates]1, >[Due Dates]1)…
-
Test if cell contains value from list
I have a task list that includes tasks by customer name. Due dates are formula-controlled by an offset from an entry date. Certain customers of ours receive "red carpet" treatment, which requires me to recalculate the due date manually. I would like to try the following automated solution: Maintain a separate sheet with a…
-
Formula for Counting Checkboxes in a row
Is there a way to count the number of checked boxes in a row with multiple columns?
