-
Days to Complete Formula for Specific Criteria
Hello all! I am struggling with a formula for 'Days to Complete'. I have a sheet from a template that previously had this formula for days to complete: =IF([% Complete]@row < 1, "N/A", [Actual Delivery Date]@row - [Date Requested]@row) The sheet has been updated and customized and the [% Complete] is no longer relevant for…
-
Formula for if Blank
Hi, I am trying to get the formula to return "Report not Received" when a cell is left blank. I have tried numerous was and am not receiving the result I am looking for. It will either return a "Report Received by Deadline" or will remain blank. Here is the current formula: =IF(NOT(ISBLANK([January '22]@row)), IF([January…
-
IF Statement based on Date
Greetings Community I'm trying to build a formula that gives me different results based on the date in one column, but one of my weaker spots is always the nested IFs. To give you context of the expected result: I have a column that tracks the different dates of Contract renewals and I want to add a new one that gives me…
-
Checkbox Formula Not Working
I am trying to write a formula that states If a value of a specific cell is equal to $0 then check a checkbox. I have written this formula and it is not working: =IF([Remaining Value by Customer]@row = "$0", 1, 0) The $0 in Remaining Value by Customer field has a formula in it to return the value so I am wondering if that…
-
Formula for multiplying with rounding included
Okay, so I need to come up with a formula that does 2 things: Multiples the numbers in ColumnA with the numbers in ColumnB Rounds those numbers up or down depending on what the nearest .5% is For example: ColumnA has 6 in it ColumnB has 70% in it Multiplying those together, gives me 4.2. I need that to automatically round…
-
Rolling Monthly % Complete Formula
Hello, I cant figure out a formula for what I need and I need some help please! I am looking for a formula so the % complete will only show a value in the previous month(s) and the current month. For right now I would like November and onwards to show up as 0, but when it becomes November then I would like November to show…
-
Combine if ISBLANK in an existing formula that pulls percent complete based on duration
I have the formula that pull the percentage complete based on the duration between 2 dates =IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, MIN(TODAY(), [End Date]@row)) / Duration@row, 0) What I'm trying to do is add the formula below to make a combined formula. Which should make the number zero if there is…
-
Any idea why when one of my criteria is from Letter 'A' through 'M' I'm getting 'INVALID DATA TYPE'
but not when the criteria is N? This is working OK, =COUNTIFS({BIN}, "N", {Status}, "Qualified Occupied", {Move Out}, MONTH(@cell) = MONTH(Date@row), {Move Out}, YEAR(@cell) = YEAR(Date@row)) But when I replace N with A i get an error =COUNTIFS({BIN}, "A", {Status}, "Qualified Occupied", {Move Out}, MONTH(@cell) =…
-
Cell reference - when original cell content is deleted, the referencing cell still shows value
I have two Sheets. In Sheet A I have my full content. I am displaying some cell content from Sheet A in my Sheet B. I created the referencing as a Column Formula, so that if I add another row to my Sheet A, it automatically displays in Sheet B. That works just find. What does not work is if I later on decide to delete a…
-
Can you have pull-down menu items with pre-assigned durations?
Is there a way of automatically assigning a default duration to a pull-down menu item? Say, a pulldown menu of activities where each activity has a pre-assigned duration e.g. "paint room" takes 1 day, "build roof" takes 5 days