-
Question about currency formatting
Hi, I have a helper column I am using to insert text into an email alert (the 2000 characters is not enough for my needs so I'm using several formulas to insert the data). Anyway, one of my columns is my "Header text" for the email and it includes the name of the person making the transaction, the transaction total, date…
-
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,…