-
Formula to have status "ball" change color for blank cell
I would like to have the status "ball" color change to red if the column cell is blank and green if the column cell has a date entered in it. PLEASE HELP!!!!!!
-
If or Index or Match....not sure what to use
I have a Metrics sheet and a Source sheet. The Source sheet has 2 columns, Area and Status. On the Metrics sheet, for each Area, I want to display that associated Status. This is the Metrics Sheet (The % Complete will be pulled from another Source sheet): This is the Source sheet: I tried: Any ideas?
-
Using Row Comments in a Formula
Hello! I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to. Any information provided is greatly appreciated!
-
First Month's Date Range
Hello, I'm looking to get a response like this: 07/01/23 - 07/31/23. I want to get the previous month's range based on the values in the column (The previous month could potentially have entries dating 9/1/23-9/25/23, for example). I am referencing another sheet's column {REF DATE}. Dates range from 7/1/23 to 8/2/23 at…
-
NETWORKDAYS WITH AN IF??
Can anyone help with a formula to track the number of days between 2 separate columns with the IF of stopping the count once a date is populated in one of those columns?
-
'Most Common' Formula
Hello, I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria. Example: Build 30 - Success Build 31- Success Build 31 - Failure Build 32 - Success The Application…
-
Working Days across a Date range
Hello friends! I'm hoping to have a column which automatically populates the number of working days in a given period from a [Start Date] and [Number of Months] columns. e.g. Start Date = 3rd July 2023 Number of Months = 2 Result = 45 days 63 calendar days – 18 days skipped: 9 Saturdays, 9 Sundays Would anyone have a…
-
Auto Populate a date if another cell contains specific text
So I am sure this has been asked, but i cant seem to find anything on this topic. I am looking for a formula that will auto populate a cell with a date if another cell within that same sheet contains specific text. Example: If [Assignment]@row, HAS "Audit", then place a date in [Audit Due]@row Searching for Specific Text…
-
NETWORKDAYS
PROBLEM SOLVED THANK YOU
-
IF CONTAINS Help!
Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.…
