-
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…
-
Looking for a formula for checked boxes xx/xx checked
I am working on a tracking type of sheet. I have 4 columns that i have inserted check marks for: D2:D301 I2:I301 N2:301 S2:S177 The check marks are great, but i would like to take this one step further and have a tracker up at the top that as an example says xx/1072 to signify how many boxes are checked out of how many…
-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
Assistance Needed with SUMIF Formula
Hello, I need assistance with a few sumif formulas. 1) I need to calculate Documents Scanned This Month and Documents Scanned Last Month. The formula should look for the word Documents in the column called "Scanning Queue" and give me the total Scanned Quantity for both current month and last month. Below is the formula I…