-
Count how many times a specific word appears in a column
Column heading = Issue Type with drop down options Open, Updated, Closed Need a formula to count how many times each is chosen Thank you,
-
Variance formula
Hi, I'd like to create a formula for caculating variance between baseline date and finish date. The baseline function doesn't really work well in SS. The logic is if there are no dates in the Baseline finish column, then keep the variance cell empty. If there are dates in the Baseline column, then calculate the networkingβ¦
-
Convert decimals (fractions) to hours and minutes
Can anyone provide a simple formula to convert decimals/fractions to hours and minutes?
-
Task@Risk
Hi. I'm trying to create the following formula for a RAID Log Task@Risk, to display a Red Flag if criteria is met: If [End Date] is blank, then "Update Date", If the STATUS chosen from the STATUS drop-down is "Not Started" or "In Progress" or "Cancelled" or "On Hold" or "Delayed" & [End Date] has passed Today's date, thenβ¦
-
Sum formula not working
I want to sum all the values in the yellow columns, however it's not happening with the usual sum functionο»Ώπ€·ββοΈο»Ώ The values in the yellow columns are all from calculations of IF(AND()) formula, as below: =IF(AND([Price Type]@row = "Regular", [23rd Total Radiology 30 Jan - 2 Feb]@row = 1), 1800, "") + IF(AND([Priceβ¦
-
I'd like to see an example to solve a similar problem
I'm trying to summarize the monthly activity of a sales person. I have the data sheet which has each person in a column, a parent row of the month, and child rows for each new week. What is a formula that I could utilize to summarize the information by sales person by month? I've attached screen shots of the sheets I'mβ¦
-
Adding Days to Date but Days Column Includes Text
I'm trying to calculate the end-date for a purchase order. Columns used in the formula are Start Date, Contract Max Length (Days), and I'm adding an additional 60 to cover a Net 60 payment cycle. The "Contract Max Length (Days)" column includes a Data Verified text option in the MS Form collecting the data. I was able toβ¦
-
Counting if there is more than 1 condition
Hello, I have a sheet where we collate applications from candidates. Starting another sheet to gather the data. I have the first formula sorted to count the applicants per month- =COUNTIF({2022 Resume Tracker Range 1}, AND(IFERROR(MONTH(@cell), 0) = Month@row, IFERROR(YEAR(@cell), 0) = Year@row)) But now I am trying toβ¦
-
Automated Notification with Contact List
I have a sheet that is populated via a form. Many of the fields are automated based on what the user selects. For example, the user selects a Workstream, and individuals are selected from multiple dropdown menus (names, not contact lists). We are now in the stage of collecting data, so the form is being filled out. I wouldβ¦
-
Need to pull month and year into a cell, no day
Hi there, I am trying to find a formula that will pull in the month and year from another cell while leaving out the day. Is this possible? I know there is not a date format for just the month and year, was hoping for a work around of some kind. For instance, if the date in one cell is 10/19/22, I want to write a formulaβ¦