-
How to have my status reflect a percentage complete
Hello, Column B has my dropdown option of Statuses (Complete, In Progress, Waiting, Not Started, & Escalated) Complete = 1, In Progress= .75, Escalated .5, Waiting= .25, and Not Started = 0 Column C is a percentage. I would like to have Column C automatically update when column B has a dropdown selected. Current formula…
-
Sheet Summary
Hi Team! I have an invoice tracker, and I'd like to use the sheet summary to indicate 2 different fields: "Total Paid" and "Total Due" My columns are "Amount" and "Paid Date" " For "Total Amount" I am using =SUM(Amount:Amount). "Total Paid" - If a date is populated in the "Paid Date" column, calculate the the total sum…
-
Show 0 if blank cell
Hi there, I have a formula that helps us determine the number of hours a project will take based on the modules created. [# modules *30]+120 The formula obviously always states 120 even if there are no modules to work on, how can I fix this to show 0 or blank cell. I've tried IFERROR, ISBLANK and IF statements and can't…
-
Proceeding Zeros to an already existing column.
Hi, I'd like to add Proceeding zeros to an already existing column Currently there are over 2000 rows in the, with a varying number of digits from 1-4. I'd like them all to be a 4 digit number. So if the column has an entered number of 1, I'd like the proceeding zeros to make it a 0001 or 501, but 0501. Is this currently…
-
countifs using 2 "dependent" columns from 2nd sheet
I need to count rows in a 2nd sheet based on a value in current row in 1st sheet. The 2nd sheet has 2 columns. 1st column is dependent on value from 1st sheet. 2nd column is a dependency based on the value in same row as 1st column. 1st sheet: Column: "Total_Tickets". Uses a countifs() based on the name found in the same…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Find the number in a second sheet and search for the latest date
Hey community, I have to sheets: In sheet 1, I will show the latest date for a special "string". This date I need to search in sheet 2. See picture below. In sheet 1: For the number 43KA123456 it gives me back the latest date from sheet 2 for that number. If the number is not found, it gives me back "not found". Sheet 1…
-
SUM IF Formula
I need to write a SUM IF formula that will pull a sum of the Federal Share for each project type.
-
Counting weekly entries from a Created By field
I am looking to count all the entries from a Created By field in Sheet 1 and deposit that count into a Sheet 2 that contains rows for each week of the year 1-53. The intended use is to show week over week counts of inquiries. Will eventually want to specify the count per support type for each column on Sheet 2 (Sales,…
-
Looking to create a formula that automatically counts X of X and returns appropriate values.s
I currently have a formula that counts how many matching cells in a column there are. The cells are a combination of numbers and letters. For example: CA0059 or CD0101. My current formula only counts the matching number, so for example is CA0059 shows up in 4 different cells it will count it 4 times. My current Formula :…
