-
Problems with formulas
i am having difficulties with my formulas . I am trying to acheive the following: IF status row is not "complete" AND due date is Today or in the past, if true Flag, if not unflag. My formula is: =IF(AND(Status28 <> "Completed", [Planned Finish]28 >= TODAY(-15)), 1) However this is the results - it is not calulation what i…
-
Is there a way to auto-hide columns based on the value selected from a drop down cell?
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Project" and "Small Project". Each distinction has its own requirements, thus making a few of the existing…
-
RGBY Ball and Date Formula
Hello, I am trying to write a formula that can work out the following RED - if the start date has past and the complete % is 0 BLUE - if the start date is in the future and the complete % is 0 YELLOW - if complete % is 1-99 GREEN - if complete % is 100
-
Counting completion status off of a group of sheets
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am trying to figure out how to pull together a dynamic number for the total number of courses…
-
Counting Completed Dates Within the Last 12 Months
Hello - I'm trying to do a formula that will count the number of projects that have been completed within the last twelve months. I have one that will count within the last 365 days, but this result doesn't match the completed per month numbers. Here is the current formula: =COUNTIF([Actual Implementation Date]:[Actual…
-
Count the number of times multiple values appear in a column
Hello SS Community, I'm trying to count the number of instances two values appear together in a cell. From the following example, I would like to count how often "Contractor" and "Vendor" appear together, and furthermore I would like to sum the budget for those instances as well. When I use the CountIf with Contains…
-
COUNTIFS error when finite rows not set
I have a formula that calculates the week number, and counts all items with the priority of 'Standard' within that week. The issue is that my 'Creation Date' column currently has 97 rows, but this will increase. The formula below works, but not if I remove the row numbers. I haven't seen this behavior before, did I set…
-
IF statement to update a column when box is checked!
Hi, I would like to update the 'Status' Column to CLOSED when the 'Done' checkbox is CHECKED.
-
At Risk Flag Formula issues/questions
I searched through the Community and found a couple of formulae that either directly addressed what I want to accomplish or I thought could be modifed to do what I want. I get the #UNPARSEABLE error for each of them. I'm sure I'm missing something basic (new user) since all of the responses to the solutions are positive. I…
-
RYG Balls Need a Little Help Please
I have contacted the help desk and they suggested for me to post a question on the forum.... 1. Get help with RYG Balls.... If start date is a date with no due date and at any % completed then yellow... If due date is 3 days in the future then Yellow.... If due date is today Red...... if due date is tomorrow yellow .....…