-
Formula using WORKDAY, TODAY, ISBLANK - #INCORRECT ARGUMENT
I want to calculate the number of days that a ticket is in Backlog. [Ticket Status]@row = "Backlog" WORKDAY([Date Submitted]@row, TODAY()) is the number of days from the date of submission to current date. I realize that my Date Submitted cell sometimes is blank so I added: NOT(ISBLANK([Date Submitted@row]) check. Now it…
-
COUNTIFS reference issue
Hello, I am trying to create a metrics sheet that pulls data from a conference room request sheet. I was able to create all of the functions except this one, which counts the total reservations per department per calendar year. =COUNTIFS({Submission Status}, OR(@cell = "Assigned", @cell = "Confirmed"), {End Date},…
-
CountIf Multiple names in a singe cell
I am looking to count the names in a single cell, with the functions citation being derived from from a list. Is it possible to do this using the countif Function, or similar? Thanks,
-
Sumifs syntax help
trying to get a sum for the number of OT sessions for each student in a given week not sure what's wrong with my formula =SUMIFS([Todays Week ]@row, {Week Number}, [Student Code]@row, {OT Student Code}, {OT Sessions},=>1) I'm trying to sum the number in the OT session column of a separate sheet if the week number matches…
-
How to COUNTIFS function with multiple criteria in one column?
Hello, I am attempting to use CountIFs via reference sheet. In my Task Log, I have an Issue Type column with multi-select dropdown properties that shows which Firms had issues. For each instance where an issue is identified, we create a new row in the Task Log with the responsible firm in one column and the issue(s) in…
-
Evaluate if a Date column is blank
I have three columns with the below formula in the "Helper - Overdue" column. This works correctly for when there is a date in the "Deadline" column and the "Item Completed" box is not checked. It also works correctly for when the box is checked. The part that is not working is when the date column is blank, it shows as…
-
Project Health Formula Help!
I am trying to add a column to my project plan to track the health of the lines in my plan based on the details in the % complete and due date columns. I would like to use the red, yellow and green symbols in the formula. Are there any formula's that you can recommend for tracking project health? I think the formula I am…
-
We have tried several IF(INDEX formulas but keep getting error messages.
We are referencing the sheet below with the “BARCODE” and “PIP” column and placing a checkmark on a separate collection sheet. We have tried several IF(INDEX formulas but keep getting error messages. What we would like to do is check a box on a separate sheet if the PIP is “Red” or keep the box unchecked if the cell in the…
-
Average using data from another sheet
Hello! I need some help with pulling from another sheet to complete my formula. I'd like to be able to demonstrate week over week improvements (or opportunities) pulling from a master sheet of data to another, new sheet pulling from specific set of key data fields. For example: On my master sheet I have information…
-
Total % Complete for 4 columns
I think this formula should be easy but I am terrible with formulas. There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns: Formula I have is: =SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) +…