-
Reference Sheet with Parent/Child Rows and Multi-Select
Hello, Sheet 1 - A sheet that contains parent and children rows with columns containing multi-selects. Sheet 2- A summary sheet that references Sheet 1. I want to count the children rows of the conditions: a) Team Red b) Area only has "West" included. I think I use COUNTIFS, but not sure how to reference another sheet and…
-
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…
-
Index comes back with no match
Im wanting to return the email address in my column and using this formula but it comes back with no match =INDEX({Email address}, MATCH([Quote Request #]@row, {Quote request #},0))
-
Change a form submission + approval needed
Hi all, I'm working on a build request is asking: use form to submit new project - DONE be able to revisit the prior form submission to change certain key fields the key change needs to be approved before data change is made on the sheet Can someone provide some ideas for step #2 ? some posts mentioned about Dynamic…
-
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…
-
Automatically Delete Attachments when a condition is met?
Hello, I am looking for a way to automatically delete attachments on a row when the work is approved. Is this possible?
-
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…
-
IF/AND Formula help please
Hi all, Looking for some help with the following IF/AND Formula please which could result in the following answers: If Task Status not equal to "Completed" then return "Currently Incomplete" If Task Status not equal to "Completed" & the task is late( End date(actual)+Time Due(Actual) are greater than their targets, return…
-
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…
-
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…