-
CHANGE ON SITE AFTER IS CONFIRMED
I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment Confirmed Arrived” column the option “Confirmed” the column “Equipment Order Status”…
-
Formula Help - multiple criteria & ranges
Hi community! I need HELP. I have been hitting my head against a wall trying to write a formula to calculate across different ranges and criteria. See photo for example of data. My formulas are not working out. What I am trying to calculate is: Countifs 1) All PEM except PAC Support Center 2) Do not include rows with…
-
Resource Management workaround for Rooms (not people)
Because Legacy Resource Management can't handle anything that isn't a registered user, I'm trying to create my own Room availability sheet. I've got columns with week numbers. And my formula is successfully looking at a start date, or end date, but can't identify the times in between.…
-
IF/OR/NOT formula: What am I doing wrong?
There are three criteria that programs must meet before we can release the hold on their reservations: 1) Covid safety plan in place 2) Approval to bring minors to campus 3) Housing plans in place Here is the formula I'm working on, which is returning an "unparseable" error message: =IF(OR(NOT([COVID Safety Plan]@row =…
-
Countifs with contains
Hello everyone, I am unable to write a formula including COUNTIFS and CONTAINS. My formula looks like this: =COUNTIFS({Range 1}; Test1; {Range 2}; "Test 2"; {Range 3}; "Closed (WECO)"; {Range 4}; CONTAINS(City; {Range 4})) I don't know how to use the CONTAINS formula well... In the city column we can find 2 types of data.…
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
-
Locking Columns/Drop Down Lists
I need to be able to protect formulas in a column for the parent rows but still want people to be able be able to select child drop down cells. If I lock the column will this stop people from being able to use the drop down lists? If so what other options do I have to protect the parent rows' formulas?
-
Multiple Functions per Cell/Column
Hi, Is it possible for a single Cell/Column to have multiple functions and if so, how do you achieve it? For reference, I am trying to track the amount of days between different date columns, however it might take a few hours/days to input the second date. Because of this the cell is filled with #Invalad Data Type. Is…
-
Need to Count Projects by Assignee AND Status
I am having difficulty getting a project count by Person AND has to be one of 3 Statuses. Currently I have this formula to look at project count by a certain person but its pulling in all projects even DONE or Archived. NOTE: The assignee can be more than one person =COUNTIF(GDC:GDC, FIND("first last", @cell) > 0) All I…
-
IF AND Formula for 5 Options
Hey Community, please help me figure this out. We have 5 options for types of projects and they are the following: Technical Services Projects Technical Services Programs Enterprise Projects Enterprise Programs ODE We are trying to output one of those five options based on the columns Project Type and Program Type. Project…