-
Help with referencing data that is input through a form
Hi all, I'm hoping someone can help me with my specific issue that I cannot seem to resolve. In our Workspace that is set up through control centre, we have a sheet called a Checklist that is populated for each of our provisioned projects. The information in the sheet is populated via a form, as there is around 50 columns…
-
Convert a Sum into Currency format $#,##.00
I have a formula that creates a note and within that note is a sum of numbers. For example, JOIN("This is your total: $" + round(sum([Number1]@row, [Number2]@row), 2)) When I use this formula, the results look like "This is your total: $34000.00" when I need it to return "This is your total: $34,000.00". When I use…
-
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…