-
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…
-
Flag column based on date & other criteria
I'm trying to figure out how to set up an alert to automatically notify someone if the entry row hasn't met criteria (checkbox) within 5 days. I was thinking about creating a flag column that kicks off an email alert but I can't figure out the flag formula. Here's what I've been trying to play with: If [Created Date] is…
-
Formula to auto calculate time difference in hours between two 24hr format times?
I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format. Once picking their starting time and end time, I would like the third column, "Total Hours", to…
-
SUM totals of VLOOKUP
Looking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? (A): Forecast Adjustment forumla =IFERROR(VLOOKUP(Category@row, {Table Category_Full…