-
SUMIF Formula ?
Hello! I am trying to make the following formula. If "Actuals (Cash-In-Hand)" is greater than "Budget" list the overperformance difference in "Over-Performance". If there is an underperformance it should stay $0.00. In this case the overperformance is $1,185,852.00. Thank you for your help!
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
-
Date Percentage Formula Help
I need help with a formula. I have two date-formatted columns ("Archives Start Date" and "Archives End Date") and I need a formula that displays essentially "as of today, we're X% of the way between those two dates". Any help is greatly appreciated.
-
New Project Plan...3 questions
Hello smart people :=D - I'm back and doing something new! I am creating a project plan from a template and trying to do a couple of things but having some challenges. I want to insert Actual Start/End dates and have those dates drive the red flags. How could I do that and what are the risks? Why is my % complete not…
-
Countif formula with date range
Hi, I'm looking for a formula which will give me the total number rows for a certain date range from my master list for my metrics. For example, I want to count the number of rows which have dates between 01/01/2024 and 01/31/24, so this will tell me how many county request have been captured within that date range. Can…
-
Date error report
Hi, I have a formula that adds x days to a date. The date is displayed correctly, but when I use it in a report, the displayed date isn't the same. For testing purposes, I added a column with the formula =[Próxima manutenção]@row+"", and the date that appears is different, but the same as the one that appears in the…
-
Automation To a Select Column
Hi, I'm trying to set up an automation to trigger when a row is added and then an email would go out to the person in the new row. When I select Alert someone and select Send to contacts in a cell there are no results found. This would be a message only with no links to the actual sheet. Any assistance on why the…
-
IF/INDEX function returning #INVALID DATA TYPE
In my function below i am trying to fill the actual start date column with a new date if the predecessor task's duration was extended. ive replaced the Predecessors@row with a number value and the formula returned actual dates, so i suspect this is where i incorrectly identify a row number in the index function. i also…
-
Can a cell-specific formula be applied to a column?
Is it possible to apply a function to an entire column that is cell-specific? I have a Start Date, End Date, and a Duration column where I’d like the Duration column to calculate the number of networkdays between the start and end dates in the row. Currently, it looks like this: (yes, I know there are negative days- I'll…