-
How to change my formula to flag yellow on due dates instead of red.
I believe this is an easy fix, I am just not able to figure it out! I am trying to change my formula so that the status icon does not change to red only once it is in progress for tasks due today. I would rather it show as yellow if something is due today, then red if it passes its due date. Here is my current formula:…
-
Help with IF, THEN
I want a calculation to run if a cell value is within a range. IF Cell X is between 1-4, THEN sum(cellZ, cellP, cellH) How do I write this?
-
Can we safely use cross-sheet references in column formula?
Hello everyone, I have a fairly large sheet (~5000 rows). I have one column whose value gets changed based on data from another column within the sheet. The source column is a country code column and the column that gets updated displays region based on the country code (EMEA, LATAM, NA, etc.). I decided to create another…
-
Summarize a set of number values with text, but some values are blank
Hi all, I am creating a text summary that pulls numbers from other columns. It's for the results of a ballot, so I want it to look like this: 2 approve, 4 reject, 5 abstain And the formula looks like this: =([Vote count: Approve]@row + " approve, " + [Vote count: Reject]@row + " reject, " + [Vote count: Abstain]@row + "…
-
Life of a Ticket
Hello friends! I am creating a log which tracks the life of tickets we open. When we change the assignment group or status of the ticket, I would like for a new row to be automatically be created, preferably a child row so I can somehow only count parent rows hopefully in totals. Is this possible? Either of these :) Thank…
-
How to create a formula that will send notifications to specific users
Hello, Im trying to create a column formula that when a user selects a certain field, the responses will automatically go to a specific person/responder and will notify them of a task that's awaiting their approval. For example: someone wants more information about a specific oncology drug, (the "therapeutic area" column).…
-
Help with Budget sheet, with different rates depending on hours
Good afternoon, I'm looking for help with my budget sheet. I need to calculate the project design cost using a rate, but when we have a change order the rate can be different. As an example for the first 50 hours I need to use the rate of $100, but then for the next 50 hours I need to use the rate of $110, and so on. I…
-
If(CountIf) Support
Hello - I am trying to count something if it meets the criteria and running into an Invalid operation error. What I want to do: If the priority in another sheet is NOT "N/A", Count the status in another sheet if it equals "New". I was trying to do this: =IF({Priority for AAG} = "N/A", =COUNTIF({Status Column} = [Helper…
-
SUM MULTIPLE VALUES IN A ROW BASED ON MULTIPLE CRITERIA
I am trying to sum the Total $ Amount of multiple items, when they meet the Account Code criteria of multiple values in a row (not the entire column). For example, in the first row, "TOTAL $ AMOUNT, 9810-420" should equal $550.00 and "TOTAL $ AMOUNT, 9810-430" should equal $100.00. The "Item... $ Amount" columns are…
-
How do you exclude a specific dropdown status from another sheet in a formula?
I have 2 sheets. One sheet (Requestors) is tied to a form for people to get information about a possible coach. Through this awesome community, I've been able to figure out how to pull the information I need from the 2nd sheet (Coaches list), and display it in an automated email to the requestor (with a line break between…
