-
FORMULA TO PRESENT THE MONTH (NAME) IN A CELL
I created a formula using -MONTH to extract the Month Number, but i want that number to convert to the name (JAN, FEB, etc) I started with pulling the Month Number from the Intake Date column; =MONTH([Intake Date - \[Select Date\]]@row) then, I used an =IF to convert the "1" to equal JAN: =IF(Month1 = "1", "JAN") I thought…
-
Need formula help to AVG a range if "Y" @row
Here is what I attempted (after tying to find help in the community threads): =AVG(COLLECT([# of Hours to Complete]:[# of Hours to Complete], [Conciere?]:[Conciere?], ="Y")) This returns a #Divide by Zero" error Here is what my sheet looks like, and I need to AVG. the # of hours for all rows that have "Y" in "Conciere?"…
-
Combining two formulas in one -
I have two formulas that work independently and am wondering if there is anyway to combine them. I've spent far too much time in the forums trying to solve it on my own but keep getting errors. The two formula's are referencing different column data on the same sheet. The sheet is showing an entire history of employee…
-
Show the next task due
All I am trying to do is show the next task in the Next Task column that has not be marked completed in the Status Column. I tried a bunch of different Index/Collect and Index match formulas but the best I can do is get it to return a blank. I don't understand why the below formula doesn't work. =INDEX(COLLECT([Next…
-
Extracting text from a string and adding it to a date to get a date in the future
Apologies if the title wasn't helpful - wasn't sure how to better summarize the problem. I have two columns - Payment Terms (Dropdown) and Invoice Date (Date). The Payment Terms column is either numbers like 30, 45, or 60 OR a string that describes the discount if paid in a certain timeframe: "1%20 / NET 60". I have been…
-
Calculate days between two dates if the date is greater than 01/01/2024
Hello, I am trying to grab the number of dates between two dates if the manufacture date is greater than 01/01/24. This is the formula I am using and it is not working. =IF([Manufacture Date]@row, >DATE(2024, 1, 1), [Paperwork/HPLC]@row - [Manufacture Date]@row, 0)
-
Can I create one workflow to notify multiple conditional paths or does each condition need it's own?
Hello, I am trying to create a workflow where specific people at a given project are notified when a request is fulfilled. I have set it up as it appears in the included picture but I am only receiving alerts when the first project is selected. Do I have to create a separate workflow for each of the projects or is there a…
-
Is there a formula that will allow me to tally previous and future meetings?
I am trying to set up a sheet using a comma delimited format within cells, to tally previous and future meetings for each client. We do schedule in advance and the number of meetings per client varies by month. We just want to know, at a glance, how many times we have met with a client in any given month, and how many…
-
IF formula question
Hello, my formula is not working, can I get some help with this. I can't seem to find the issue. =IF(AND(Applications1 = "commissions", "internal"), IF(AND(applications1 = "Eyefinity PM", "External"), IF(OR(applications1 = "BERT", "Internal"), IF(OR(applications1 = "Makeabiliy", "Internal"), IF(OR(applications1 = "RTE…
-
Trying to get formula to show blank in a cell if the date column is blank
Hello, I am using this formula in a summary field to grab the most recent entry. I do this by have a 2nd column that converts the enter date into just the month format. If the date field is blank it causes an invalid data type which then populates in the summary field. Here is what I am using: =INDEX([Member Service Level…