-
Changing a start date, but keeping subsequent dependent dates within "months"
I work in sales for a construction company. Our forecasted timelines for projects are often pushed, and that affects my monthly revenue projections. I've broken down our forecasted project timelines by month per row, but if the start date gets pushed, I'd like for the dates of the subsequent rows/months to STAY WITHIN…
-
IF formula
Can someone tell me what I am doing wrong with this formula? If the checkbox is checked, I need the value to be zero, if it is not checked then I need the formula to work: =IF([Existing current WJA server]@row = 1, 0, IF([Existing current WJA server]@row = 2, [How many WebJet Admin Server Instances required?]@row * 4))
-
Deposit Summary
The attached sheet is a sample of a project for tying out cash at the end of the month. The left side (Deposit amount) is the amount that was posted in our billing software to the ledger. The right side (Bank Credits) is the amount that hit the bank. We need to match our ledger to the bank statements and tie them out.…
-
How to compute Index Match and pull tolerance in a formula
Good afternoon, I wonder if someone could help me to write the following formula. I have been trying for a couple of hours with no luck. I create two separate sheets INJ - Critical Tolerance (always fixed values - no user interaction) INJ - QUATO - Setup Sheet (User will specify platform and Parameter from an online form)…
-
How would I modify my JOIN/COLLECT statement/formula
Here is my current statement/formula (example below shows 2 different key numbers assigned to the same location, which is what I want it to do). =JOIN(COLLECT({Key Number}, {BUILDING Range}, Building@row, {LOCATION Range}, Location@row, {Assigned Range}, "1")) which draws on information from another sheet I need to know if…
-
Countifs & HAS referencing a separate sheet
Hi there, would really appreciate some help with this. I have 2 sheets created; 1) Deployments Complete and 2) Monthly Billing. Sheet 1 is data that is updated daily on my deployment project. In sheet 1 I have a Comments column that is text format. Sheet 2 is where I summarise the data from sheet 1 and report from these…
-
Looking for the simplest formula to pull in the max value for the date of child rows
We have parent-child rows for reports, I would like the parent row to have a formula that pulls the most recent date in the child rows into the date column to keep the parent in the correct order on the sheet. TIA
-
Countifs for items completed YTD by quarter?
Hi everyone, first time poster here. I need a formula that will count Buy closings YTD by quarter. The best guess I have after reading other posts is: =COUNTIFS([Buy close date]:[Buy close date], > DATE(2021,01,01), [Buy close date]:[Buy close date] < TODAY, [Closing Q]:[Closing Q], Q1) It's not working but I can't quite…
-
How to get distinct column from source sheet into report.
I am creating a report. There is list of carriers in source sheet. I want to bring distinct carrier name into my report. I checked it is 126 in total. what I did I just copied and past distinct carrier but If someone add new it wont show I believe. How can I bring in my report. If someone add a new carrier then it will add…
-
Nested COUNTIF with AND
I am trying to use a nested COUNTIF formula with AND function. Column X - check if value is "1" Column Y - check if value is "2" Column Z - check if value is "3" I only want to see the count where all three statements are true. Help!
