-
Formula results are affected by the word "ing", why?
Hi everyone, i have an issue. I have formula which is influenced by several columns and conditions, here's the formula. =IF(OR(CONTAINS("PW"; Task@row); CONTAINS("PC"; Task@row); CONTAINS("PF"; Task@row); CONTAINS("WC"; Task@row); CONTAINS("WF"; Task@row); CONTAINS("CF"; Task@row); CONTAINS("FC"; Task@row); CONTAINS("FF";…
-
Count Distinct Collect result is showing as 1
-
V-LookUp to see if the same number ID is found in two separate sheets
Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?
-
IF with HAS and Multiple Choice dropdown.
This is a complicated one so bear with me. We have an form users fill out and one of the questions on the form is multiple choice where they can select more than one answer. There are 3 correct answers to this and fourth option that is incorrect. We've been asked to give to give them "10 points" if they get all 3 correct,…
-
Cell to hold multiple values
Hello, I am trying to create a formula (or if there is a better way please let me know) for a cell to have multiple values if true. So i have one column with a drop down with 10 different options and 10 more columns. If someone picks the first option then they only need to fill out 2/10 columns and if they pick the second…
-
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)
-
trying to use countifs with multiple criteria's and a multiple selection drop down list
i've tried countif, countifs, count/collect. has, contains, i either don't get the correct value, or different errors such as incorrect argument, unparsable, ect. The formula that is shown comes back with a value of 0, when on the reference sheet it should be 1 for this column, during this month, for this employee. The…
-
Auto populate an email address from a Drop down list choice
I have a drop down list of Doctors names that staff pick from on a form (over 90 doctors). It will just be 1 name that is chosen from the list. I need the doctor's email address to populate in the sheet (not on the form) in the cell next to the name. I have a separate sheet with the doctor's names and email addresses. I…