-
VLOOKUP from Form Input
Hey guys, I've been unable to find a solution for this one. I have a sheet from which I "VLOOKUP" values from another sheet. This another sheet gets its values from a FORM input. When I reference another sheet as a lookup_table, I select the whole sheet in which the FORM data input ends up, the new line is never included…
-
Formula help
I have a formula set to change to RYGB balls depending on children. The formula is as follows: =IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green"))) This formula works great. I now want to add another statement to this that will…
-
EOMONTH formula request
I would really like to see the EOMONTH formula. There is a way to do that with the current formulas, but as an example of how long it is, here is what's needed for setting a due date to the end of the current month if there are more than 10 days left in the month or setting it to the following month if there are less than…
-
Formula to change Green Status to Red Status when date has expired
Hello, I am looking for a formula that will automatically change Green Status to Red Status when the date has expired? Thank you!
-
Merging Formulas
Help! I need to create a formula to display a Budget amount for a particular team. The Team column is a Count Column, while the Budget column would be a sum. Can i do this? (eg: i want to know the budget # associated with a function lead and have that budget add it's self up) Essentially, we have multiple functions within…
-
Delta/Slippage Formula
I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules. I have individual columns for Original Finish (Date), Current Projected Finish (Date), and Change Order (CO) Days that are populating dates and numbers with cell linking from the…
-
Need % Complete rollup to exclude tasks not needed in overall calculation of % done
I have a master project plan where all tasks are listed. I want to use this plan for any project and if a tasks is not needed I would like to keep the row but have a status of N/A. I would then like to have the % complete formula for the hierarchy to only calculate those rows that are needed so the overall % completion is…
-
Using formulas for Date validation within 7, 14 and 30 days
Hi, I am trying to use the following formula: =IF[Due Date] <=7, "Red", IF[Due Date] > 7 and <=14, "Yellow") IF [Due Date] > 14 and < 30, "Green") How do I do that, I tried to create a new column to show the colors, but I keep getting Invalid Operation. =IF(([Due Date]1) > 7, (AND([Due Date]1) < 14), "Red"), IF([Due…
-
Formula Question
I would like the column "Done" to be checked automatically if the % Complete is changed to 100%. I am using the formula below which is not working: =IF([% Complete]3 = "100%", 1) Any suggestions?
-
Nested IF Statement for Flagging Duplicates
Hi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns. For Example: First Last Job Jeff Smith Programmer Jeff Smith Designer Jeff Smith Designer In this scenario, I want a flag checked off when ALL 3 appear…