-
Multiple email contacts in the IF statement
Hi, I have custom contact list column, which displays email contacts based on the conditions. Here's an example of that column: =IF(AND([Column1]@row = "Value1", OR([Column2]@row = "Value2", [Column2]@row = "Value3")), "email@email.com, email2@email.com, email3@email.com", IF(AND([Column1]@row = "Value5", OR([Column2]@row…
-
Priority Level Based on Whether a Number is Higher or Lower
Hello, I am trying to write a formula that will calculate priorities as such: If Live Count = <15,000 return Critical to Priority column If Live Count = <10,000 return High to Priority column If Live Count = <5,000 return Moderate to Priority column If Live Count = >5,000 return Low to Priority column
-
Automate a response field
I would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can be recalculated as above. Unclear how this can be done.
-
Formula says #INVALID OPERATION.
I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION. =SUM(COUNTIF(Priority:Priority, "High") - (COUNTIFS(Priority:Priority, "High", Status:Status, "Complete"))) The Priority column is a symbol column…
-
Nested If OR formula, Better way?
Hello, I am writing out a =If(or)) function right now and it will be way to long if i do it step by step and i am wondering if there is a better way to do this. So my formula is =if(or(Location@row="Place 1",Location@row="Place 2"), "USA",if(or))... I have about 150 places i need to attach to 20 different countries. Is…
-
How to correctly use INDEX(COLLECT())
I am trying to create a cross-sheet formula that pulls the data from another sheet if it meets 3 criteria. In the source sheet, I need the following criteria met: 1. "Month/Year" column to be the same as the "Month/Year of Report" column in my target sheet. 2. "Activity code" column to be "2105532" 3. "Name" column to be…
-
Meeting Minutes - automate MM#, author and attendees by date
Hi All, Hope you're all well. I wanted to filter the meeting minutes based on the selected date. I created hidden columns that contain the meeting number, author and actual attendees for that date. I tried using the formula below but it didn't work. The peach background means this is where I change the date manually, which…
-
Workday function
I want to calculate the working days from the start date. However, we have Sat as a working day which I have configured in the Gantt setting. (So we have 6 working days). When I use the formula WORKDAY ([Start Date],38), from 3-Mar-2024, I get the output as 16-Apr-2024 - which is correct. 3-Mar-2024 being Sunday. When I…
-
Future Date Calculation to a nth Day of Month
Hello, looking for help with this formula. Need to calculate a future date based on the [End Date] Conditions: (1) Only display a future date if [Ord Amt] is true; (2) Future date to be one month earlier then month of [End Date] unless; (3) [End Date] month = January, then Future date is to be December and one year earlier…
-
Form Confirmation Options
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?