-
Need a formula for counting information based on date
Hello, I need a formula that can help me calculate the sum within a column based on date. Not sure if this can be achieved. We are updating information on a weekly basis and I have different rows for the same date. I need a formula to give me the sum based on the date. For example, on 1/17 I will have 6 rows with data that…
-
Editors cannot overwrite cells with formulas
Hi there, In a sheet I've few cells that have formulas, columns were those cells are aren't lock, however the users cannot overwrite the formulas, any idea why it may happen? The idea was to create formulas as a guidance but editors should be able to overwrite them, in this case isn't happening, they cannot enter values in…
-
Sheet Summary Formula for Due Dates
Hello, I have two separate column Status and Due Date and I'm looking to create a formula on the sheet summary for the amount of items that are due today and past due. Is there a way to create one?
-
Multiplying cells from different sheets
Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the corresponding cell from Sheet 1 and then be able to copy/paste the formula so that it…
-
Text change based on value of number
Hi All, I was hoping to create a formula that changes the text of a cell based on the number in another cell. Here is what I'm trying to make the cell display at each value range: Value is under or equal to 20 - Cell to display "N/A" Value is between 21 & 30 - Cell to display "PB to Contact" Value is between 31 & 40 - Cell…
-
Automatic ticket numbering by location
Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a combination of the community abbreviation, the year, and then the number of work…
-
Average If Certain Criteria is Met
Hello, I'm trying to calculate the average number of days but only for columns that meet the criteria. I have a formula that is calculating the networkdays between two dates. This column is called Implementation Time (Days) - BD. I am now trying to average those days but only for when the Work Type column = Hospital…
-
Formula to average a range in another sheet corresponding to cells that contain parts of text
I can't seem to beat this formula. I've tried COUNTIF, COLLECT, CONTAINS, and when I'm not getting an error I'm getting 0. I want to see the average of successful deliveries below for all Up to Date emails in Q1. In the sheet I'm working with I'm trying to say: If any cell in the Month/Year/Email column contains the words…
-
Calculating Average Work Days with Stipulations
Hello, I'm trying to calculate average work days that each command takes to return a request. However, it has to meet several other stipulations. -"Type of Request" has to include "FOIA" (drop-down column multi-select) -"Date Forwarded to Command #1" (in the formula it's "Date Fwd to C#1") is a date-only select, that…
-
Parent RYB Status Ball - Changing color based on child status RYB ball
Hello, Another request for information! I have a parent status ball that I would like to change color based on the 2 deadline status balls and the dominant completion ball (i.e. row 1 & row 2 - then row 3 being the dominant ball). The colors are as follows: Row 1 & Row 2 - They will be green, yellow or red. Row 3 - This…