-
AVERAGEIF with multiple criteria
Hello, I am trying to find the Average calculated time of a column(Avg Time) when it is a specific Status and Px Code. For Example, The average time code '1234' is in status 'Approved.' I've tried these two formulas: =AVERAGEIF({Avg Time}, AND({Px}, Px@row, {Status}, Status@row)) =AVERAGEIF(AND({Px}, Px@row, {Status},…
-
Referencing another sheet to match check boxes?
I have two sheets that share information back and forth. On sheet 1 (Hiller - Concord) I have a checkbox that I will check once a job has been closed ("Closed - Final Payment Received"). I want to reference that checkbox in sheet 2 (Submittal Log) so that once a job has been closed, I can move the information from this…
-
Calculating Variance between Due Date & Date Delivered
I am new to smartsheet and I am looking for some guidance: I want to calculate the delivery variance between the Due Date & Date Delivered. Both the columns are Column Types is Date (I also tried with Text/Number, but doesn't help.) The issue I have is that for any date that it is delivered on or after the due date, it is…
-
INDEX COLLECT not working
I am unable to get a value returned using INDEX COLLECT. No matter what I try, I keep getting the IFERROR text "Not Found". I have tried using VLOOKUP as well with the same results. I have deleted the reference sheet and reuploaded the data to a new sheet and still get the same results. Can anyone help me with this? Below…
-
Formula to auto populate Health based on End Date & Status columns
I can get the formula to work in pieces, but not as a whole... My formula: =IF(Status@row = "Complete", "Green", IF(Status@row = "Not Started", "", IF(Status@row = "In Progress", "Green", IF(Status@row = "On Hold", "Blue", IF(Status@row = "Delayed", "Red", IF([End Date]@row < TODAY(7), "Yellow", IF([End Date]@row <…
-
SUMIFS only for negative number
Hello ! I have two columns to follow the progress of my team planning. One is for the reference end date, the one I set at the beginning and to which I must stick. And the second one is the adjusted end date, the one that is reviewed once a week to get closer to reality. I have a formula that counts the variance between…
-
SUMIF Formula for Adding Multiple Lines With The Same Date
I am looking to create a summary sheet for daily productivity based that would feed from a separate data sheet. The data sheet has multiple lines with the same date on it. I have tried multiple formulas that are not working. I want to add the "# of pallets/pieces" with the same "appointment date" from my "BOC Receiving…
-
Formula Assistance
I am trying to identify how many times over the year a report was either received on time, late, or not at all. The reports are due to be received by the end of each month. The first attachment is the sheet which is being referenced. The report name being listed down the left side, and then identifying the date each month…
-
Typing Minutes of meetings directly in dashbord
HI all We do our meeting with a dashboard a couple times a week. We have a chart that shows the development of all our current projects and products. Sometimes we need to write notes to the projects, (which we have a grid for in the project folder), but it would be great if it was possible to write notes directly into that…
-
How to return a blank cell in my formula results when the referenced cell is blank?
I've been trying various different ways to add to my formula to return a blank cell when the date cell I'm referencing is blank, none seem to be working. The formula should give me a 3 if the date is 0 - 90 days in the future, a 4 if between 90 - 120 days in the future, a 6 if 120 - 180 days and "over 6 months" if more…