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, cust…
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 …
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…
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 che…
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 divi…
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
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], >[Du…
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 t…
Hello! this is my first post and I would appreciate help. I want to setup a cell (call it "Cell1") on a row that is empty until a different cell ("Cell2") is clicked with a checkmark; upon Cell2 recei…
