-
using a form to input new data means my formula no longer works.
hi, I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to stay as [column name]1 even when new information is put onto the sheet. Please can someone…
-
Calculate Average for Duration Column
Hello, I have a column in a sheet that displays the duration for every project in our portfolio. I would like to calculate the average project length. When I use the AVG forumula, I get an error that says "# DIVIDE BY ZERO" Does anyone know how to get the average? Thanks!
-
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…