-
How to run multiple IF functions independently of each other in the same cell?
I'm having trouble figuring out how to get multiple "IF" statements to run simultaneously. I need it to check the presence of text in multiple columns, but the Value if True, shouldn't stop the formula from checking the other boxes, and it shouldn't only return a value if ALL conditions are met. So, I need an IF statement…
-
Automatically add people in Contacts column depending on the Country
Hello everyone, My team has a sheet with Submitter, Country, Recommendation columns. Each Recommendation is related to a Country. According to the Country, the Submitter field would have to be automatically filled with the respective people for the specific country. The Recommendations are added through a form. In…
-
Visual / Report for data in a multi-value drop down column
Hello! I have a drop down column with 14 options and the ability to allow multiple values per cell. It is a sheet to show different company internal initiatives, when they are happening, and which team they impact. The impacted team is the multi value drop down. I want to create a visual that shows how many things are…
-
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…
