-
RYGB Lights Not Changing with Dates
I am not sure why my lights wont change based on the dates: =IF([Original Due Date]@row < TODAY(14), "Yellow", IF([Original Due Date]@row < TODAY(7), "Blue", IF([Revised Due Date]@row > [Original Due Date]@row, "Red"))) Would like: Yellow: <14 days from today Blue: <7 days from today Red: Revised Date < Original Date
-
Formula not working
Hello, I have a late task checkbox that isn't working. The formula is to compare the baseline start and finish duration to the actual start and finish duration, if the actual dates are longer, the checkbox should automatically check. =IF(AND(NOT(ISBLANK(Duration@row)), [Duration (Actual)]@row > Duration@row, ([Finish…
-
IF NOT FORMULA with COLOR STATUS * HELP PLEASE**
WHEN (NO actual survey date entered yet) If Scheduled survey date is beyond 7 days from today date – Green If schedule survey date is within 7 days from today date – yellow If scheduled survey date is today or past – Red Once an actual survey date is entered it is – blue *** HERE IS WHAT I HAVE BUT WONT WORK**…
-
Formula Assistance (COUNTM??)
Hello all, My team and I are hoping to build a formula to do the following: First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color." So, for example, the answer for this would be 4 (because there are 4 items in the "Color" column that belong to Group A).…
-
I am trying to use sum ifs another sheet column is between dates and equal "spm"
=SUMIFS({Sofia}, ="SPM", {Sofia (Shawn) 2021-22 YTD},AND({Sof}>=(2021,8,1),{Sof},<=(2021,8,31),{Sofia (Shawn) 2021-22 YTD}))
-
Cross sheet Index/Match with row deletion or addition
Apologies if this question has been posed before, however I have not been able to find a solution by browsing through the community (there is also a good chance I'm approaching the problem incorrectly). I have started building a master project sheet that contains several columns with project related information. I would…
-
Countif with column and cell reference instead using "XXX" name
Hi, i am building a large list of client that i going to use to create Dashboard with counting items per each client. My question is (maybe it is very basic), is there a way that in the formula Countif i can refer to the cell and column instead or using the "XXXX" name in the formula? here the formula that i am using and…
-
Simple task health formula issue
I am using this formula that I adapted to my comun names from one that was posted here elsewhere. =IF(AND(Start@row > TODAY(), [% Complete]@row = 0), "Blue", IF(AND(Start@row < TODAY(ROUND(Duration@row / 2)), [% Complete]@row >= 0.5), "Green", IF(AND(Start@row > TODAY(Duration@row * 0.5), [% Complete]@row < 0.5), "Yellow",…
-
COUNTIFS and with 2 different values in same column with a value in another column?
I have two different columns lets say "Colone" and "Coltwo". Colone has a value GZ22 and GZ21. Coltwo column has two activities "Completed" and "Just Completed" I'm trying to create a formula to count which counts the activity "Completed " that are done in GZ22 with the activity "Just Completed" that are done in GZ22. and…
-
Cell link from another sheet based on conditions
Hi all, I hope someone can help as I've been racking my brain trying to work this out! I have multiple sheets that work together of which the data changes each month (it's based on electricity bills with varying monthly kWh (in pence) rates). I essentially want to link a particular cell from one sheet to another sheet,…