-
Why is a formula not triggering unless someone opens the sheet?
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
-
Sheet Summary Formula for Adding Date Range
I am trying to count how many trainings we have starting in each quarter. I am trying to use: =SUMIFS([Learning Request Name]:[Learning Request Name], [Proposed Delivery Start Date]:[Proposed Delivery Start Date], >=DATE(2024, 01, 01), [Proposed Delivery Start Date]:[Proposed Delivery Start Date], <=DATE(2024, 03, 31)) I…
-
Campaign Spend Flighting by Month
I am trying to create a formula that can calculate spend by month based on a campaign flight and total budget. Ideally, I would have a column for each month. I've tried using a helper formula which worked in excel of =MAX(0,MIN($E2,EOMONTH(C$1,0))-MAX($D2,C$1)+1) to get the days in a month and then multiple daily spend by…
-
CountIFS based on rolling FY and item.
Hi Everyone: I am trying to count how many of X has been completed (based on completion date) in the current FY based. Ideally I'd like the count to automatically update what the current FY is. I think this should be a simple formula, but for some reason, I'm at a loss. Thanks in advance for your help.
-
CountIf AND
Hi I am trying to write a CountIF AND Formula for Chart The Column choices are Case Carrying vs NonCase Carrying The rows are Region 1 to Region 6 So for example: Countif the person is in Region 1 AND is Case Carrying. I keep on getting different errors. Thank you for your help!
-
Query Formula Help!
I am currently creating a search query that will allow anyone to search for a name and get the corresponding information. For some reason, when I try these different formulas, I am receiving the error message even if the name is correct. I've included my references in the formula as well. Can anyone help with this? Current…
-
Evaluate a date and return week #
I have a date input in a worksheet and need to somehow lookup what week # the date falls in. My weeks begin Monday and end Sunday. Screenshot of 'Date Range' worksheet below. So if my input date in a separate worksheet is 03/15/24 I want to return 11. I am using this in a 'LookUp' worksheet. Screenshot of 'LookUp'…
-
How to create a formula to show last day of the month
I am trying to create a monthly timeline template, where once I set the start date for the project, the 'Billing Month 1 start' column collects the date and the following column 'Billing month 1 Close' column indicates the end of that month. From there The following 'Valuation 1' column is the result of the prorate then;…
-
Inches abbreviated as "
Hello! I am trying to write a summary formula that will count the number of valves by size within a column. My problem is that the size description recently changed from the word "inch" to the symbol " as the inch abbreviation (ex: 2" for a 2-inch valve). My old formula was: =COUNTIF([Valve Size]:[Valve Size], ="2 inch")…
-
Nested COLUMN FORMULA for PARENT and CHILD
How do I control the Parent and Child with different formulas? This is the column formula I currently have but I ONLY want it to apply to the CHILD =IF(AND([MTO QTY]@row > [ORDER QTY]@row, [IS CHILD]@row = 1), "Red", "Green") THEN for the PARENT, I want it to look at all the CHILDREN and if ANY is RED then the PARENT…