-
Successors formula (German setup)
Hello community, I'm trying the new successors formula in a German setup, but doesn't matter what I try I'm always ending up with an #UNPARSEABLE error. Neither the German (= JOIN(SUCCESSORS(Spalte@Zeile),",")), nor the English (= JOIN(SUCCESSORS(column@row),",")) version seems to work.
-
Extracting part of text (seperated with a carriage return ALT Enter) with a formula
Hi, I have a huge sheet with a comments column (column A). In many cells in this column there are multiple lines of comments i.e. 2/3/22 blah blah bla 1/3/22 blah blah blah I need to create a new column (column B) to extract via a formula all of the text in column A but ONLY the 1st line of text before the carriage return…
-
IF/AND/CONTAINS Formula
I'm trying to gather info from another sheet and use it in an IF formula, but I've not been able to make it work correctly. Here is the current formula: =IF(AND(CONTAINS([38-2021]$1, {Vacations/Holidays - DDQC Range - weeks}), {Vacations/Holidays - DDQC Range - assigned} = $[DDQC Person]@row), "YES", "NO") It returns…
-
Pass promised date
how to write pass promised date on a project =IF(OR([Overall Project Status]@row = "Past Due", [Promised Completion Date]4 >= TODAY(), "Yes", IF([Overall Project Status]@row = "Complete", "No"))) It says incorrect argument
-
Issue with Embedded IF Statement
I am working on a training tracker and am struggling with a formula that, while long, seems fairly straightforward. The column is a checkbox. And should be marked off with a check if the row is deemed a "required training". I am having an issue with the first part of the formula (The bolded portion below). Basically, the…
-
Countifs
Hi, I have been searching the boards and am not coming up with what I want so I am hoping someone can point me in the right direction. I have a sheet with a multi-select column. In the column you can select: A B A, B I want to find the 3 formulas that will count the number of times A shows up by itself, the number of times…
-
Contacts; Updates, references, multiple sheets
Hello, I would like to compile an ever-growing list of employees to one sheet and reference it to several others only needing to make changes to one. I need employees in certain departments to be available on certain sheets in a column titled "Operators". Is there a way to do that? Thank you, Bess
-
Using a range of checkboxes for an IF statement
Hi, I have a column of checkboxes, and next to them are cells with just regular text. I want the text to be referenced in another sheet only if the checkbox is checked: I can get it to work for just one value fine with =IF({checkbox reference}, {personal goal reference}), however this is just one pair of cells and I would…
-
INDEX? I may be making this too complicated but I am drinking from the firehose right now.
I have a sheet that is fed from a form. In one area of the sheet there is a column called Additional Notes. Most of the time this is left blank. But when it is filled in there is a column next to it that has a check box showing if the issue was closed (checked) or if the issue is still open (unchecked). I am creating…
-
Formulas are working in the grid but not on the cross reference
Has anyone had this issue before? I'm using a formula to extract the created time from the system generated crated time stamp using the formula below. =RIGHT(Created@row, FIND(" ", Created@row, 1) - 1) The time stamp is working well in the sheet but is adding a comma to the output when I try to cross reference it in…
