-
How do I pick a range based on a status to use within Rank
Hi, I want to prioritize projects based on a Status. Below you can see a list of projects Ranked in Sore order. If the Priority Category (Status) for a project, I then want to exclude them from the Rank process. In other words how do I only Rank projects with a Status of Active, and not include those that have closed in…
-
Changing MMDDYYYY date type column to YYYYMMDD format when referenced in another cell
The formula I currently have works to an extent, however, it omits the leading 0 on months and days. For instance, I get 2023-8-14 instead of 2023-08-14. Is there any way to add the zero? Here's what I have right now: =IFERROR(YEAR([Invoiced Date]@row) + "-" + MONTH([Invoiced Date]@row) + "-" + DAY([Invoiced Date]@row) + "…
-
Why is this function not working?
=SUMIFS([Hours Left]@row, [Assigned To]@row, "Person's Name", [Due Date]@row, >=DATE(2023, 8, 1), [Due Date]@row, <=DATE(2023, 8, 29)) I have values in the "SUMIFS" column, but it does not work. What is wrong. It is giving me the output of all my values being zero.
-
Calculating sheet based off data in another sheet
I am working between several sheets. I am trying to pull back what courses may be missing for either Fall or Spring, respectively, and which account is left to be charged. My first sheet, Count (below), is where I'm trying to have the quick visual: So I want my Active TAships (below) sheet data to calculate into my Count…
-
We are trying to count how many applicants applied in the last 7 days for Delta client
The formula we used is : =COUNTIFS([Avature Application]:[Avature Application], Client:Client, "Delta", @cell <= TODAY(), [Avature Application]:[Avature Application], @cell > TODAY(-7)) Once we get it for this sheet, we want to do the same for a few sheets and add them all together to know the total. we use this sheet as…
-
Helper column formula to identify if "Month Requested" was the previous month
Hi! I really thought I had this one but I am getting an INCORRECT ARGUEMENT error. I have created a help column to flag if the "month requested" value in my sheet is the Previous Month. I need to flag rows that are previous month to use in a filter for a report as I will be sending the report out the first day of the month…
-
IF formula not working for a drop down list
Hello, I'm trying to equate a numerical value to a drop down list when I receive a form entry. Here is my list: 4 - very clear 3 - clear 2 - somewhat clear 1 - not clear The formula I entered was =IF([Training Objectives]@row = "1 - not clear", 1, IF([Training Objectives]@row = "2 - somewhat clear", 2, IF([Training…
-
Creating a formula to show status based on time of input date
Hello all, I am trying to create a formula. I need the status of a field to change color to indicate when its time to perform a task, which is based off of the input date and would change two weeks after. For example, if the task was done 08/14/23, that date would be added manually to the row and the status in the row…
-
Calculate # of Incidents Within A Month
I have a sheet that is recording data, we have a field for the date of an incident. I have a Roll Up sheet that is counting the data from the main one, with a number of different items. Is there a way to have a formula that counts the # of rows that have a date in a specific month? I want to be able to pull the number of…
-
formula error but only with one specific data
it's strange but the formula works on all other rows except this one - Dept Code 1000 =INDEX({Functions}, MATCH([Select the Department Code for this request]@row, {Functions Range 2}, 1)) Thanks for any help!😀
