-
Help With Index Match (#Invalid value)
I am trying to return a Contact value Cell from a lookup table, in the Column "Assigned Contact Email" according to "Week * + Day*" and "Shift Assigned To" in that Row This is what I want it to look like. ^ This is the other sheet with the look up table. ^ This is the Formula I have used. ^ ^ For the formula, Red is the…
-
Requesting help with syntax of formula with multiple ranges
Background: There are years (0 through 5) that have processes (1 through 25) and each process has roles (1 through 10). In the attached image, I'm adding a formula in the Test_A1 that should check within all roles/processes per year to determine if it is unique (used only once) within the entire year. I do already have an…
-
I want to make a widget with hours consumed.
Hello! So, I want to make a Widget in my dashboard that shows that hours consumed by my resources out of their allocated hours, for that i need to SUM all the hours they put on their TIME ENTRY sheet, i made the formula and in works on SHEET SUMMARY being =SUMIFS(HOURS:HOURS, EMPLOYEE:EMPLOYEE, "xxxxxxx") (xxxxxx being the…
-
IF condition is true, copy a value into another column
I have a sheet where multiple people have to approve an item before it is 'approved'. I am needing to copy a cell from the Cost column into the pending, approved, or rejected column based on the current status. So if the P/R/A column equals "P" I need the $ in the cost column to populate in the Pending Cost Column, etc.…
-
COUNTIFS and NOT Formula Creation
Hello, I have a table of data that looks like this: I am needing to create a formula that will count all of the "1" in each column, that do not contain "OPEN" in the name field. So far I have created this formula: =COUNTIFS(Sun3:Sun27, 1, Employees3:Employees27, NOT("OPEN")) Does anyone have an idea for a formula that will…
-
NEW! COUNTIF not blank....
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], )) Attempt #2: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
-
Update a previous row from a submitted form using workflow.
I have a form with several fields that are completed by a project manager to show the latest update of a project. Once the form is submitted, it goes to an approver, and a workflow moves the entry to a second approved sheet when approval is given. A workflow then sets a new date as the next update field, and additional…
-
COUNTIF differnt sheet
Hey I have a sheet with a column "Status" and I am trying to write a formula to count totals for the different statuses. Reference sheet name is "Conference Room Request Form" the status I am looking for is "PO Cut" =COUNTIF({Conference Room Request Form v2 Range 1}(Status:Status,"PO Cut")) I get a #UNPARSEABLE What am I…
-
Formula to Return 3 Different Answers Based On Cell Value
Hello, I am trying to create a formula that returns 1 of 3 answers based on the value of the selected cell. Right now I have it set up to show me Complete/Incomplete based on the number 4 being in a column, but it would be more useful for me to see "In Progress" for cells that have a 1, 2, or 3 in them. My current formula…
-
Copy Automation
Does anyone know of a way to use the copy automation without copying EVERY column of the original sheet to the new sheet? Also, can I make it so that the sheets constantly create themselves every week while constantly updating the corresponding sheet using automations?
