-
SUMIF formula issues
I am trying to write my 1st SUMIF formula based on a suggestion from a colleague but not coming right :( We are setting up a budget tracking sheet for the organisation to use as many people will be adding rows to various categories I am trying to write a formula that will check the Category in the "Activity" column and…
-
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…