-
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) +…
-
How to setup an "If" with dates involved?
Pretty new to the SS scene. I am looking for assistance/guidance on how to create a formula to check the current date, and compare it to another date in a different column and if the difference is greater than XXX days have it provide a symbol. I have tried googling and have only found a bunch of functions:…
-
Stumped on a SUMIFS for Fiscal Year (FY)
Hello everyone, I am a bit stumped on a solution. I tend to not like to hardcode information into a formula. I was working through a solution to help manage a Business Development (BD) pipeline. With the help of the community, I figured out how to do a YTD. But then I was thinking that it didn't make sense to have the BD…
-
IF statement inside a COLLECT
Why do all of these formulas work: SUM(COLLECT({Value}, {Location}, Location@row)) SUM(COLLECT({Value}, {Location}, <>"")) SUM(COLLECT({Value}, {Location}, IF(index@row=1, "Boston", Location@row))) But this does not: SUM(COLLECT({Value}, {Location}, IF(index@row=1, <>"", Location@row))) I'm trying to understand this…
