@Leibel Shuchat Hi Leibel- Thank you so much for your help yesterday for the formula of Create Date - Modified Date= Time Spent. I wanted to ask if i could convert the results to number Xd : XXh : XXm Also if you could help me on getting the average in "Sheet Summary" for each month per associate? I have 9 other associates…
SUM Providing Wrong Number
This discussion was created from comments split from: SUMIF value exists, leave blank if cells are blank (nothing to sum).
Reporting on Linked Dependencies?
Hi, I have a program with 40+ project plans many of which have inter plan dependencies (with cells linking the dependent task or output from one plan to anouther). As part of my QA process, I want to create a report that will identify these linked dependencies in each project plan either as a sum total or listing out the…
Combining two IF functions
Hello! I am trying to make is a formula that says "If there is a complete date then calculate the # of days that that task took from approval to completion. If complete date is blank then calculate how many days has passed since the approval date". I have two formulas that work independently but I can't figure out how to…
Count of Multi Select Options Across Entire Sheet
I can find some reference to this that others have asked but it seems slightly different then what I'm looking at. Consider the following: Column: Type of Issue A, B, C A, B A, D A, C, D C, D I'm looking to place a count of each of the items above on a dashboard across the entire sheet. Any insight would be appreciated John
COUNTIF with dates pulled from cells?
Hello! I'm trying to run a count of the number of entries on a sheet, where the "needs analysis assigned date" is greater than 5 days prior to the "date requestor contacted" date for that same row of data. Example: Row 1: Needs analysis assigned date: 11/1/2022 Date Requestor contacted: 11/2/2022 The date difference only…
Using RYG Symbol Column Based on Two Dates.
Hello, I am trying to use an IF statement where if one date is one week or less than another date, to display the yellow symbol. If the first date is after the second date, display red symbol, if it is within 2 weeks or more of the second date, display the green symbol. I already have a two date formatted columns set up…
How to sum cells from different sheets?
I have six sheets with numbers in each cell. I want to make a 'TOTAL' sheet that sums up each corresponding cell in each of the six sheets. For example, sum the A1 cell in Sheet 1, 2, 3, 4, 5, 6. And then sum the A2 cell in Sheet 1, 2, 3, 4, 5, 6. Basically the A1 cell in the TOTAL sheet should be the sum of Sheet 1, 2, 3,…
Numbers separate by commas read as thousands
I have ONE cell with various numbers/text that users get to input via a form. The input varies from all numbers separated by commas or can have some text as well. If it is just numbers separated by commas and there are no spaces in between those numbers and commas then cell is read as number. I need some sort of a way /…
Notification at multiples minus a number
Hello, I have a spreadsheet where each row counts hours, then a column keeps a running total of all hours. I would like to be notified at certain intervals as every 150 hours I need to do a task however I need some prep time so I would like to be notified 20 hours before 150. So when my column value reaches 150, 300, 450,…