-
Median with criteria
Hi, I am trying to figure out the median number of days a site is in construction IF it is a Tier I, II, or III. I am referencing another sheet. Range 6 is referencing a column that has each site's construction duration. Range 7 is the column the lists the sites tier level. =MEDIAN({REFRESH - MASTER TRACKING SHEET Range…
-
Selective non working days/holidays for sheet level
Hi there. I currently have all my project sheets set to exclude non working days and holidays because the overwhelming majority of our work is done during weekdays excluding holidays. However some of the activities have a duration that is irrespective of that. For example, there may be an experiment that takes 6 weeks from…
-
Using IF with Networkdays
Hi All, I am trying to calculate the number of days in SS and adding a clause that if the difference is greater than 45, it should return "No". If it is lower, it should return "YES". Unfortunately, my code is not working, and I am stuck. The formula I am using is the following: = IF((NETWORKDAYS([Sent to NewOrder]2, [Sent…
-
How to fix INVAID DATA TYPE, referencing start and end dates, & duration to calculate % complete
I am using a project sheet with the formula below to calculate the % complete based on the duration of the task, and start and finish dates. However, if there are not dates in the start and finish column I am getting an INVALID DATA TYPE error. I've tried using IFERROR in my equation but I cannot get it to work. I plan to…
-
Multiple formula
Hello everyone, I tried to use multiple formulas, but for some reason it is working together (one-by-one they are working). What I want to do with this: I have a machine checking sheet, where the sheet send me a notification, if I work with any of my machines. Every machine has a group nr (1-5), what defines ow often I…
-
Request for formula
Good evening, I am looking for a formula to achieve the following: Column 1 name: login Column 2 name: supply type There will be multiple login names within column 1, if there is a repeat login I would like to count the matches in column 2. Example is listed below, login and supply type would be auto filled by a form and…
-
Bring data from sheet B to sheet A based on criteria in sheet B
I have 2 sheets set up, I need data from one sheet going to another based on a value in a cell on sheet B, if this condition is met I need 'Project title' to be taken from sheet B to the formula location on Sheet A. The condition is that the cell in question is 0 if its anything else nothing needs to happen. I have tried…
-
How do I add a third argument to countifs formula?
I am trying to only show dashboard data from the sheet IF the submitted date is from the current year - we do have a helper column for the submitted year but I am unsure how to incorporate it within my formula below. I am trying to count if the status is Working, Next up- top opportunities, Pilot/implemented,…
-
Nested IF formula for children rows only
Hi, I hope you will be able to help me. I'm trying to write a formula that will change the task status, depending on the date. I have done the below formula and it is working great: =IF([Actual Finish Date]@row < TODAY(), "Completed", IF([Estimated Finish Date]@row > TODAY(), "In Progress", IF([Estimated Finish Date]@row <…
-
Formula Question: IF Not Blank, Do "This"
Smartsheeters! I have a use case where I want to reflect "yes" in a column if a certain range of columns has text in it AND "no" in that column if that range of cells is BLANK. I tried this formula below and it is not working. What am I missing? =IF(ISBLANK([SALESFORCE Data Error: Late Fee % or Grace Period]1:[YARDI:…