-
Charting with dates using the data on the Report Item
The labels for my date are weird. How do I fix? The information under each Due dates are file names.
-
I need to calculate past due items with 2 column dates
Hi I need to create a formula that help me to calculate the past due items but using to columns with dates. One is the the first column with the "Expected closure date". This will be the primary column to check or validate. But we have another one called "Amended closure date", that will have another date that probably…
-
Symbols for Status
Why are my words not translating through to symbols? The formula seems to work since its returning the text, but ist converting it to symbol form =IF(Status@row = "Assigned / Not Started", "Empty", IF(Status@row = "In-Progress, On-Schedule", "Green", IF(Status@row = "Delayed", "Yellow", IF(Status@row = "Complete", "Blue",…
-
Formula help to match contains
Hello! I have 2 sheets: Sheet 1 contains [UserId] column Sheet 2 contains [Assosiated User] and [Machine Name] columns I need to Use [UserId] to look up if [Associated User] contains text to match [UserId] and return the value of [Machine Name] at row Just cannot seem to figure it out. Any help is appreciated!
-
COUNITFS w/Ranges from Multiple Sheets?
Hi all, I'm trying to create a COUNTIFS formula that will look for the same criteria within multiple sheets (5+ sheets at a time). I have my criteria in one sheet, and want to look across other sheets for instances of that specific criteria, then tally up the instances in the original sheet w/the criteria. I'm setting a…
-
Finding Average of Cells in Another Sheet
Hello, I am trying to find the average of "% completes" percentages from one sheet to another that meet a certain criteria. Here is the formula I have attempted however, I am receiving an "Invalid Operation". Is there a way to accomplish this without selecting each cell individually? =IF({Team} = "Marketing", AVG({%…
-
IF Formula - 2 Conditions and 1 Flag
I have a column that houses a flag to notify if the billed hours breach the budget. But I am trying to use two conditions where it doesn't run if Contract Type contains T&M. My first attempt right now: =IF([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, (IF([Contract Type]@row,…
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Count previous month items
Hi i am creating a metrics for a Dashboard and i just need a count of new items that were created in the previous month. I am using as base the "created date" column. For your reference i already have one that is counting the items created during the current month and it is working. What i don't know if where to include an…
-
How to count number of tasks and due dates of another sheet
Hi, I'm trying to make Metrics sheet which I would like to calculate the number of tasks of each person by name and also their past due tasks I did some formulas but they seem to be #INVALID Below are the formulas I did for tasks : =COUNTIFS({Name of other sheet Range 1}, FIND("Name", @cell) > 0) Formula I did for past due…