-
=INDEX =MATCH to pull up dates.
Hello, I've been wracking my brain trying to understand why this doesn't work. I have a sheet with some project-related data including the columns "START DATE" and "END DATE" which are date columns because they have dependencies on the duration column etc. I'm making a new sheet for resource allocation, and I need to bring…
-
Process with parent row
Hello, i have a sheet with all quoatation i sent to client and some of them moved to status "approved"/"void". the process is after i get the PO, and after i finish the job that the client buy from me i forward request to my worker for issue a invoice. i have the summary for all quotation i sent where now is it (waiting…
-
Need Formula Help Multiple Date Columns, count days, if blank choose other column
I have Multiple date columns for approvals. I want to find the number of days between columns, but some are blank so I need it to choose another date column based on what I set. I've included example data.
-
Is there a way to use a checkbox (or formula) to bypass a required form field or turn it off?
We have a contact information form that will be distributed quarterly so the respondents can provide contact info changes and updates within their organization to ensure that we always have up-to-date information. Most of the fields are required however, in the event that the respondent has no new changes or updates to…
-
Formula to calculate the average number of days between all dates in a range
I have tracking sheets that record "sent" and "executed" dates. I am attempting to set up Sheet Summaries to determine the average number of days between all "sent" and "executed" dates in the sheet. (I want to do this without adding an additional column and calculating averages for each row). It seems I need some type of…
-
If statement that takes a column value and if meets a criteria, subtracts a number
I have been trying for several days and could use some help. In the image example here, I need to set 'Final Quote' to be one of the following: A) If [Apply TCC] is checked, then take [Quote before TCC] value, subtract 200 from it, and put that answer in the [Final Quote] B) If Apply TCC is not checked, I just need the…
-
Count rows where ANY of the criteria are met.
I need to count all the rows in my sheet where any one of the three required columns are blank. I want a Sheet Summary formula that stores the result. Psuedo-code: CountIf Status is blank OR if Owner is blank OR if Department is blank For reasons I do not want to get into here 😁, I do NOT want to use a helper column for…
-
how to use COUNTIFS and OR together
Trying to create a formula to collect a number of specific rows added in a separate sheet in the last week, last 2 weeks, etc. I have a formula that works for getting the number for this week : =COUNTIFS({Week Number}, [Todays Week ]@row, {OT Student Code}, [Student Code]@row) but I'm having trouble getting it to work. I…
-
Does anyone know how to convert this SUMIF Formula and REF a date from another sheet
Hi, Were looking to take this active formula which is currently working and replace the date ranges from another sheet (Cross Sheet Reference) . Does anyone know if this is possible ? Because it is time consuming to replace the date range on each formula, we want to be able to edit the date range from another sheet.…
-
Ancestor and Checkbox Formula
Hello! I'm trying to write a formula that I just can't seem to get right. I've got a project with several ancestor levels that I'd like to report on. I'm close, but I just can't seem to get it. I've added a Parent Row helper column with a check box. I'd like the check box to equal True (checked) if the Primary Column is…