-
IF, date with status column
I have a sheet with two date columns- Completion Date and Due Date. I also have a Completed on time column with Red, Yellow and Green Harvey balls. I want the ball to appear green if the Completion Date is before the Due Date and the ball to be red if the Completion Date is after the Due date. I originally planned to do…
-
How to use "OR" when having several IF statements
Hi, I posted a question earlier today so this is similar but maybe a different way of going about the solution I'm looking for. I am trying to figure out how to use "OR" when having 3+ actions in a single formula based on if a field is blank or not. My scenario is this: ORG Code 1 Object Code 1a Object Code 1b Object Code…
-
Ignoring Blank Dates
I have a sheet that is checking for past due dates. This formula works to add a check mark when the task is completed on time: =IF([Task Closed Date]@row <= [Due Date]@row, 1, 0) But it counts the blank dates in "Task Closed Date". I have tried mimicking other formulas that utilize ISBLANK, but none of them have worked.
-
Stop Formula reference from applying to whole column/sheet
Hello, I have a formula I am trying to apply to only certain cells. See below: =IF(ISNUMBER([Column15]@row), IF([Column15]@row >= {LL5}, "5", IF([Column15]@row >= {LL4}, "4", IF([Column15]@row >= {LL3}, "3", IF([Column15]@row >= {LL2}, "2", "1")))), " ") Then I want to copy and paste this formula to a different cell on the…
-
Formula that compares multiple cut-points and renders desired number
Hello, I am trying to render a number from 1 - 5 based on cut points. I am pretty sure I need a pretty long formula from this but was wondering if anyone could help me to make sure I am on the right track for my solution. Essentially this is the desired outcome I am looking for. I have one sheet with "cut-point ranges" for…
-
Formula for counting how many times a cell has been updated
Is there a formula that you can suggest that will count the number of times a Date has been updated in a specific cell? For example; if I have a date of 4/1/2025 and I update it to 4/21/2025, I would expect to see "2" in a cell titled "Number of times date updated". Delays can happen for various reasons and I would like to…
-
Trouble with IF statement and date format conversion
Hi all, I'm having a formula issue that I need human support for. [AI is failing to translate it properly]. Here's my scenario (I'm so close!): I have an orange text column [Delayed Result Date] that sometimes contains MM/YYYY format and other times MM/DD/YYYY format. I need to make it a (yellow) date column [Delayed…
-
Annual Business Budget Template - How to change periods to align with specific months?
I am using the 'Annual Business Budget' template. I want to start the budgeting period from April 2025 (and therefore should be Period 1). However, once I add an expense from April, the sheet still picks it up as Period 4 (assumes month 4). The formula for that cell is large and complex: =IF($Value$2 = 12,…
-
How to do a cross sheet reference
I cannot believe I do not remember how to do this!!!!! I need to create a Cross sheet reference. Now I will be referencing a cell that will be TEXT, not a number. This is the sheet I will access for my formula. I have circled in Red the sheet name and the cell I want to reference. It will only be this single cell, not a…
-
Help with multiple IF ISBLANK statements
Hi, I am trying to list values, comma delimited, from a number of columns based on if the previous column is blank. So for example, based on this table: Object Code 1a Object Code 1b Object Code 1c Object Code 1d Object Code 2a Object Code 2b Object Code 2c Object Code 2d Object Code 3a Object Code 3b Object Code 3c Object…