-
How do you link certain information from a form to a sheet or report?
I am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which shows as a column on the sheet. And lastly, the user who is filling out the form willโฆ
-
Multiple Not options in an IF(And Statement
Hello, Right now I have a working formula: =IF(AND([End Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0). using this to trigger a risk flag. I'd like to add more status values into the Not(Status@row portion. Looking to add 3: Complete, Ongoing, Cancelled. These are 3 status values where I do not want an at riskโฆ
-
Summing columns
Hello, I am trying to write a formula to look at one column in a reference sheet, and if that column equals yes, it'll total another column in that same reference sheet. I assume an IF statement is correct, but I cannot get the syntax right. Thanks for your help!
-
Comparison/Highlight help
Hello! Trying to figure out the best way to compare data for some servers. What I want to do is something like: for all rows where [Shortname] is identical, compare [Provisioned Space], [Memory Size], and [CPUs]. If there's a mismatch, highlight the cell. Is something like that even possible? I want to compare prod and uatโฆ
-
Compare Columns Across Sheets
Hello, I'm trying to reconcile a bank statement with our Cash Flow log. I'm trying to compare a value on one sheet (the Cash Flow Log) with a range on the other (the bank statement sheet). If found, I'd like it to return "Yes" on my Cash Log sheet. I'm getting the Unparseable error message. I did insert the referenceโฆ
-
Formula questions within a Sheet
Hi. I have a sheet that has formulas within this formula (Category (let's just say). I'm trying to reference specific wording within the category of the sheet. It's very hard to explain but can it be done? I can share my sheet with you. Thank you, Colleen
-
INDEX(COLLECT( is returning the same value over and over, help!
Hello all, I'm using the below formula to return values from column (Reference Specifications(document number/ITP numb), but it keeps returning only the first match (1070-06-CTSC-38QT-0009_01), how can I return all other items in the category ๐ =INDEX(COLLECT({FLOC Docs Submission Info-ETS_Aug11 Range 5}, {FLOC Docsโฆ
-
Counting in a Summary field with multiple conditions
I need to use a Summary field to Count when the following conditions are met in a Sheet: If Indent Level = 3 AND End Date is between a specific date range (using TODAY), AND the job is not complete, AND the Task Owner is ANY of the following: CopyeditAMT@user.com or PadletAMT@user.com or LayoutAMT@user.com Here's what I'mโฆ
-
SUMIF & FIND returning #UNPARSEABLE
Hi, I am trying to get the sumif function to work for me and I am having trouble. I am trying to sum the PO amount of invoices in column PO Total if the CType column has "Cabling" in it. For some reason I am getting #UNPARSEABLE. Any thoughts? This is the formulas I have tried so far: =SUMIF({CType}:{CType},โฆ
-
duplicates formula
Hi Experts: I would like to identify the duplicated in column Model# and than mark the once which have the lowest article#. The one marked in red are the once which should be marked in column model count. It's getting complicate as the article# is build out of letter and numbers, it's build in alphabetical order. Do youโฆ