-
SUM formula pulling 0 no matter what. Issue with using multiple formulas?
I'm attempting to have all resources check off each of the meetings they attend on a weekly basis and then pull in number of hours based off those responses. I've created a checkbox column for a meeting and then a number/text cell the right right. I wrote a formula saying, "if checked, populate with a 1.5, else keep null".…
-
Symbols not changing based on the value in another cell.
I entered: =IF(%3 > "0%", "Red", IF(%3 > "50%", "Yellow", IF(%3 > "85%", "Green"))) and all the cells are red. Not sure why the formula is wrong! . The icon is in the column "Indicator" and the value is in the column "%". Any help much appreciated
-
If Status "Complete" how can I set it to automatically update the color on the RYGG balls?
We would like to do conditional formatting or a function so that when the Status column is marked 'complete', it will automatically update the RYGG Ball color in the column next to it. Does anyone know how to do this?
-
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…