-
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…
-
Project Dependencies enabled but % Complete not working
I've enabled Project Dependencies as shown with the columns assigned. However, the % Complete column is blank and does not auto-complete. Suggestions? The other supporting columns Start, Finish, and Duration have relevant data. There are some blank Predecessor cells. I appreciate the help.
-
CountIfs Question
I am trying to use the countifs formula to fill in my request metrics sheet. I need to count how many times one person has been assinged specific items from a drop down. =COUNTIFS(Category47, {INNOV_Request Tracker Range 1}, [Request Status]:[Request Status], "Analysis Approved", "Project Approved", "Task Approved", "Under…
-
Formula yields "0", should be "12"
Not sure why this is not calculating? It seems it doesn't like that the numbers derive from a formula as when I change the number to a value, it calculates. Thank you!
-
SUMIF with two conditions and a checkbox
Hi Everyone, I'm currently trying to come up with a formula using sumif (or sumifs) with multiple conditions. I'm trying to sum the item value of every row in my sheet ONLY IF the patient ID of the rows is the same AND "Fiscal Year 2022" is checked. Currently I'm trying the formula: =SUMIF([Fiscal Year 2022?]@row, 1,…
-
Find This Month
I'm trying to add a formula that will tell me if a date in a cell is this month. If a date is present in the reference cell, I get an INVALID OPERATION error. What am I missing? =IF([Date Completed]@row = MONTH(TODAY()), 1) Thanks!
-
SUMIF (calculation formula)
I have a formula I need help with: =SUM([Approved/Contracted Budget $$ (Total)]:[Approved/Contracted Budget $$ (Total)]) + SUMIFS([Requested Study Budget (Submission)]:[Requested Study Budget (Submission)], [Approved/Contracted Budget $$ (Total)]:[Approved/Contracted Budget $$ (Total)], @cell = "", Approved:Approved, 1)…
-
Question with using IFERROR(INDEX(COLLECT formula
I am trying to use the index/collect statement to pull the job number based off of the PO # and the Part #. If there is nothing, then I want it to leave the cell blank. However, I get an "#INCORRECT ARGUMENT SET" error. This is the formula: =IFERROR(INDEX(COLLECT({Job #}, {PO #}, [PO Number]@row, {Part #}, [Part…
-
My SUM formula yields a maximum of 56, but I want to cap it at 40.
I have a form where various answers to questions will give the applicant 2 points. If the applicant answers all questions, they would get 56, however, we are capping it at 40. How can I stop the counting after 40? Thank you!
-
Can VLOOKUP return multiple row results?
Hello - A bit stumped and would appreciate some advice. I am trying to lookup values in Sheet 1 and populate the ID into Sheet 2. In Sheet 1, I have Intake Status and ID columns as shown: I am trying to pull the ID into Sheet 2 for any instance in which the Intake Status is New. I used a VLOOKUP formula as follows:…