-
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?
-
Autoupdate Formulas based on user entry
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 receiving the checkmark, I want Cell1 to autoupdate with the present date. Is that possible? thanks!! CVM
-
Link between two values (in 2 different columns)
I've created some values for my "status" column (In Progress, Delayed, etc.) and I've created some symbols to match these values (green, red, etc.) in another column. I use both. I'd like to link those values, ex. : if I choose "In Progress" in column A, then the green symbol will automatically appear in the column B. How…