-
Help with IF... Again
I can't seem to get the hang of formula differences between SS and Excel. Here's what I need: I am trying to populate a status column based on a numerical value in another column. If the value is 197 or higher, I want a value of Yes returned. If lower, a value of No should be returned. Here is what has not worked for me:…
-
How can look for specific data in a column and match it on Sheet 2 (in SS)
Sheet 1 I want to put a formula in Sheet 1, column [PSPEC Product Requirement], that looks at [References]@row on Sheet 1, then matches that references on Sheet 2 [References]. Sheet 2 Then copies the content on same Row on Sheet 2, [PSPEC Product Requirement], and puts it in Sheet 1, [PSPEC Product Requirement] I've tried…
-
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…
-
Is it possible to add the current date for an email alert?
I am trying to add the current date when sending out a weekly notification. As part of the customized message I would like to add the current date in the subject field/line. Is that possible?
-
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).…
-
Auto Number Column Duplicating
Good Morning, I have an automation setup for when an individual orders an XL the row duplicates for the Standard size along with the XL. What I cant figure out is why my auto number duplicates instead of applying the next auto number. In the screen shot below you will see that the third row is a duplication of the second…
-
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…
-
How to create a chart from a report!
Hello! I am trying to create charts using multiple sheets so I created a report. Although I am not able to figure out how to make it a chart. When I go to chart, it is all grayed out and won't let me select anything. I read that you needed to have a summary section and a group section, so I included both, but I still can't…
-
Auto populate Date
"I need assistance with a formula in Excel. I'm trying to automatically calculate due dates in Column J based on the difficulty level specified in Column I. If the difficulty level is 'Hard,' I want the due date to be 15 business days from the received date in Column J. For 'Medium,' it should be 8 business days, and for…