-
Using If And with symbols
Hello, I'm currently trying to write a formula and am running into issues. I've added a "Project Health" column with red, yellow and green symbols. I would like these to change automatically using the following cells to determine. If "Arrival Date" is blank, and "Customer Requested Delivery Date" is within 2 weeks, red If…
-
How do I only get the 25, 26, 27, etc out of 2025, 2026, 2027?
I need to pull out the last 3rd and 4th characters of a long year format CCYY where I only pull out the YY. So, in my example, I need to find the year 25 out of 2025. 26 out of the year 2026, 27 out of the year 2027 and so on. Basically ignore the first two characters of the long year 2025 so I will only be seeing the 25…
-
VLOOKUP/INDEX/MATCH Function When Using Automation To Input Date/Time
Hello all. I currently have two sheets. The main one is where people make requests, and I need to calculate when a person 1. Starts the request, 2. When it's on the next stage, 3. When it is completed. So I set an automation to copy the row onto the second sheet when the status is changed to "Start", "Next Stage",…
-
Calculating Time Duration
Hello everyone - I would appreciate some assistance with calculating time. I have been through the 19 page discussion on time and have tried multiple formula combinations, but cannot seem to resolve the specific issue I am having. Basically, I need to be able to automatically calculate the hours and minutes between various…
-
Maintain delimiters in a join() column when exporting to excel.
Hello, we have a bunch of columns with multiple selection dropdowns. When I export to excel the selections are concatenated without spaces: I tried to create a helper column using JOIN(): which mostly works, although it only ever shows a space between the text, and not the delimiter. However, on export to excel the helper…
-
IFSUMS using word and numbers
Hello, I am building a matrix sheet to pull data from a source sheet and trying to use an IFSUMS formula, but have received various outcomes #UNPAREBLE =SUMIFS(({Evt Support Level},[Event Support Levels]@row , {Event Month}, May1)+sumif({Event Year}, 2025)) #INCORRECT ARGUMENT SET - =SUMIFS({Evt Support Level}, [Event…
-
Pulling data from another sheet based on two criteria
Hello! I am having trouble getting this formula to work.. The goal is to pull the quantity of an item from a reference sheet to this sheet if the Spec #@row on this sheet matches an EAN on the reference sheet, and only if the Disposition value reads "Released". This is the formula I have cooked up, but get an…
-
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
-
In the case of DIVIDE by ZERO, I want cell to show "" nothing or hyphen.
I'm getting percentage for referrals that result in new business. For forward months (Aug-Dec) there are no referrals yet so the formula is dividing by 0. How can I adjust the formula to return nothing or a dash for those months? This is the formula that returns the right numbers if there are successful referrals in a…
-
Count per Day
Please assist- I have one grid and I have : 4 Coordinators Status is Completed and Completion Date I want to get the Daily count of Completed per Day. I have this table below.