-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Adding Text Value if checkbox is checked
I have two columns - One is a checkbox, the other is a text format. I'd like to write a formula that essentially says, "If checkbox is checked (true) then populate the word "Checked" in the text cell. Else if checkbox is unchecked (false) leave text cell empty". Are there any formulas out there that can do this? Thanks, -PJ
-
Find the value of the next month based on today.
How do I add 1 month to today? I don't want to add 30 days or anything, I just want to get to the next month and I have to be able to cross years. so if today is 2/1/2015 I want to find March is next; if today is 12/31/2015 I want to find Jan is next. Do I need a lookup or is there a date function that would get me this?
-
Counting Formula
What formula do I use to count how many times a name shows up in a column? For example: I have a column titled "Last Name" I need to keep a running count of how many times "Smith" shows up in this column.
-
Formula to collapse rows
I am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occurs. I would like to add that onto this formula: =IF(COUNT(CHILDREN()) =…
-
What is wrong with this formula in totaling in parent row?
I have a parent row I just can not get to toal the "Win Ratio" (it is a percent) if there is a ZERO in one of the child rows! It is driving me crazy! The colums are: Phone Calls | Accts Created | Win Ratio The Daily formula works even when there is a ZERO in it... I am using this: =IF(AND(ISNUMBER([Phone Calls]18),…
-
Date Formula in a Gantt Chart Cell
I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate + 10 The gantt chart start and end date columns use the Date/Time type of cell and Date…
-
Help! sum children if word1 and if word 2 are in row
I am trying to sum children in a column if two specific words are present in a row(s). IF "word1" ANDIF "word2" are present = sum of children
-
Combine 2 or 3 cells into one?
I have a webform that collects data for a request, Department, Type, Etc. These are separate columns. I would like to somehow filter the some of the information received into one column, which would then be a code for that particular request. The code is then used in other locations as an identifier. Is there any way to do…
-
Check box without overwriting formula ?
Hi, Here's the problem I'm facing. For each task, I'd like the two following columns : - one checkbox - one harvey ball Users can either update the harvey ball or check the box. Can the box be checked : - Automatically when harvey ball = full" (=IF([Harbey Ball]= "Full", 1, 0) - AND manually by user, without overwriting…
