-
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:…
-
Formula issue showing 0-5 Stars
Can anyone identify the error in this formula - it should show "Three" stars in the column as it's counting 3 true checkbox cells. However it will only return the "Empty" stars result. Obviously the number of stars formula result is based on how many boxes are checked.
-
How would I split text separated by commas into new cells?
Example, in one cell I have the text "Boston, MA, USA" How do I split that to have Boston in one column, MA in the second, and USA in the third, all on the same row?
