-
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…
-
Change cell automation not working
I have an automation to change the value of one cell based on the value in another cell in the same sheet. The change is to occur when triggered. The source cell value is based on a VLOOKUP formula referencing another sheet. The cell with the VLOOKUP value changes based on the formula, but the automation to trigger a…