-
Help Separating Data from a row in One Sheet to Individual Rows in Another
My team updates documents (docs). We have two sheets that we call trackers: Document Tracker: Our main sheet tracks which documents are being updated. In one column we have the document title and in another column we list any record #s that are driving the updates to that document. Record Tracker: On another sheet we track…
-
Return Multiple Values from a Lookup of Multiple Values
I have a training feedback form, and classes have multiple instructors. When the student picks multiple instructors, I need to look up the corresponding email for each instructor, usually only 2. you can see from my screen shot, I am getting an error if there is 2 to lookup, is this even possible or what is a recommended…
-
Move a Row Based on Information in a Different Row
Hello, I have a sheet with all the computers in our department. When they reach an expiration date I created a form for someone to enter the replacement computer's details. There is a field on the form to select the "Old Host Name" of the computer that is being replaced. That's the only identifier I can use to link the two…
-
Conditional Formatting Based on Modifier
Is there a way to do conditional formatting based on who modified /made changes into the sheet? I have multiple users covering projects and would like to be able to see who was responsible for editing each task. This particular workflow needs to use a horizontal schedule/flow versus a vertical one like most projects.…
-
Return value from another column for all Rows and set column to "column formula"
This formula is producing syntax error when I try to make the column a "column formula". Is there a workaround? As we add new Rows (copied from different sheet), I want all values in Client Name column to equal Task column Row 1.
-
Counting Unique Values, but only if they are within a certain date range
As the title says, trying to count rows, but only unique values and within a certain date range. Formula I'm trying to use: =COUNT(DISTINCT(COLLECT({SO Number}:{SO Number}, {Date}, AND(MONTH(@cell ) = 8))) Example Data: Sales Order Number = {SO Number} and Actual Ship Date = {Date} Any help please
-
Getting Data From Another Sheet to Populate in Another Sheet when Conditions are Met
Hello, I currently have 2 sheets that I am working with: the first is the "Original" sheet and the other is a "Metrics" sheet, which pulls data from the original (being used for Dashboard charts). The "Original" sheet has an "ID" column, a "Status" column (either "OPEN" or "CLOSED"), and "# of Days" column. On the metrics…
-
Return "Yes" if a date range includes a certain month
I am trying to return either a "Yes" or "No" value in columns for the months of the year if a date range for a project or activity has dates in that month. For example, if a project starts on 2/15/2022 and ends 4/15/2022, I would want to have "Yes" in the February, March, and April columns and "No" in all other month…
-
Add data based on project owner?
Hello, Hoping for a simple add of data based on another columns drop down selection. Looking to add up my minutes based on when my name is selected Looking to do this from another sheet Please and thank you
-
Duplicate Values: =If(Countif doesn't work with concatenated formula.
I am trying to identify duplicate values in a column titled [Program ID]. [Program ID] is the result of a concatenate formula: =[Site Num]@row + "." + ProgNum@row The result of the above formula is a decimal number like 7.1, 8.4, 50.3, etc. I am using the following formula in a helper column to identify duplicates in the…
