-
Please can someone help with this formula
I am trying to calculate how many "qualification" stages there are in a given fiscal period for example Q4-2023, I know I am missing something but every variation of Count if formulas I have tried do not seem to work, it will be something really simple, that I am trying to make to complicated, but any help will be…
-
Nested IF Help!
Hi all! I'm working on a formula that will give me the number of days a work item has been processing with our support team. I've identified the following variables: 1.) When {IT Ref #} is not blank, then I want to subtract two date columns ({Agility Creation Date} - {Created Date} 2.) When {IT Ref #} is blank, then I want…
-
Forms question
Hi all, Is there a way to get a form submission to attach to a specific row on my sheet? For example, I want an employee to fill out a daily form and rather than have the form submission create a new row, I want it to attach to the date that is selected on the form to the same data pre-populated on my sheet.
-
Return a "blank" cell if my date column didn't have a date
Hello, Trying to figure out how to integrate the VLOOKUP statement to return a "blank" cell instead of an error message if my date column didn't have a date. Thank you!
-
Want to flag overlapping dates AND times
Based on information I've found here, I've created a formula that identifies overlapping times that occur on the same day, but I'd like to adapt it to incorporate items that occur over multiple days. This will be used for booking of equipment. Here is what I have so far: =IF(COUNTIFS(SAP:SAP, SAP@row, [Start Date]:[Start…
-
Helper checkbox not working on reference sheet
I have multiple line items for a order in one sheet(Request Sheet) and in another sheet (Order sheet) where I have clubbed all the items in single row, based on the order ID from request sheet to order sheet I want to check the Quantity checkbox and update in the Order sheet, I tried index match formula but its not working…
-
If formula with several criteria
Hi, I was working on a formula last week, but I am still struggling with a second criteria on this. the way its set up, updating the field depending on dates being input into others. this works well as follows; =IFERROR(IF([Client review Required]@row = "Yes", IF([Actual Submit Date]@row = "", "Pending", (IF([Actual…
-
Counting identical words in a column
Hello everyone, Please I need help with a formula that helps me count how many times the word "diabetes" is repeated in a column called "MRA ACTIVE CODES" (1727 rows). I have tried the following formula, but it doesn't work, it gives me 0. =COUNTIF([MRA ACTIVES CODES1:MRA ACTIVES CODES1727], "*diabetes*") Thanks in…
-
Index Match, how to recognize multiple values?
Hello, I have an issue with my index match formula. I want to locate the facility for a serial number. This works perfectly when there is only one value inside. However to reduce the amount of columns and options on the corresponding form, I changed it to one column that has multiple values. The formula is having…
-
Multiple approval with Multiple Condition in Workflow
Dear Team, Is it possible to set Multiple Approval with Multiple conditions. I have below scenario I have created Approval workflow with 8 level of Approval and it's working fine and smoothly. Later I have added Conditional of Department in the 1st Level of approval that, if Department = B and Section = X then it's…