-
Managing Multiple Audit Sheets
I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants,…
-
Is there a limit to the length of If/And Statements?
I have the following statement and it works for the bold section but when I add the italic section I receive an 'UNPARSABLE' error. Thoughts? =IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "<25"), [Column2]2, IF(AND([From Calculator]2 = "<100", [From Calculator]4 = "26-50"), [Column3]2, IF(AND([From Calculator]2…
-
Formula Help Part 2
Hi there, I would like to count all of the projects in my portfolio that are launching in Jan, in Feb, in March, etc. I have a Date column called Upcoming Launch Date. I posted previously and received this formula which works (January example): =COUNTIFS([Upcoming Launch Date:Upcoming Launch Date], IFERROR(MONTH(@cell), 0)…
-
Copying comment text into another cell but only when a certain value is triggered
Hoping you can help! I'm trying to setup a formula where if I have a Red RYG ball in a cell of a task row then the comment next to it copies into a different cell (on the same sheet) for reporting. I know I could just create a report which looks at values in those columns and trigger only when there's a red ball along with…
-
Help on Countif formula
Hi I am trying to create a countif formula with multiple criteria . Heres what I am trying to do Countif Column1 = 1 and column 2 = N/A or Received at home I tried this formula but assume it is a check And for all 3 conditions as I get a value of 0 =COUNTIFS([Campus Id #]:[Campus Id #], =1, [ASA Not Given in ERSquad]:[ASA…
-
Cross sheet formula - Reporting by week
Hi Again! Is it possible to create data that provides QTY of selections checked per week and record this on a sheet automatically with formula. So we are managing live installation projects, with a high turnover of projects. Our main sheet is called PROJECT MILESTONES where we track all the live project activity. Within…
-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Card view is deleting my formula
I've created formulas to automatically calculate status based on start/end dates and % complete. If you switch to card view and move things within this view it deletes my formulas. How can i lock users from card view or what are my options here.
-
COUNTIFS or other appropriate formula
Hi, I'm attempting to create a count of the occurrences of text in a column called 'DOCTOR' from a list of drop downs in rows 2 to 32 inclusive: FULL DROPDOWN LIST: CLINIC 1 CLINIC 2 CLINIC 3 NOT ROSTERED ON COMPANY BUSINESS UNPAID SICK DAY UNAVAILABLE I'd like to get an automated count of the instances of the following:…
-
If(And) #unpareseable error- help
Hi I am trying to write a formula to check values in two columns to set a flag on or off. If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error. Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1). Any guidance…