-
How to get distinct values from a column, then shows their maximum number?
How to create a formula that can get me the distinct name list from the left table then get their max values? Please help me
-
Nested Formula in Sheet Summary
I am looking to return a summary sheet for manager review. I want a formula to run if the status is "In Progress" and it's been assigned to a specific team member, I want the value returned to be a list of the types of projects in progress. The sheet is set up with "Assigned to" as a contact list, "Status" to be a drop…
-
Blank Rows in Form Submission - Deleting rows ends by column calcs
Hello - when I have a new form submission it seems to come in at the bottom of my column calcs. For instance I have a calc set up to row 375 and the submission will come in at row 376 and wont be included in my calcs. If I delete all the rows in between like several posts have suggested that ends my calcs at the line above…
-
Date Formula
Hello, I have a "Renovation Start Date" and a "Estimated Renovation Completion Date" column. If the "Renovation Start Date" is blank and does not have a date, I want to the "Estimated Renovation Completion Date" column to also remain blank. However, if the "Renovation Start Date" is does have a date I want the "Estimated…
-
Nested IF formula
I am attempting to count cells that have text or not and using this formula: =IF(SUM(IF(SUM((IF(ISBLANK([T2 Last Name]@row), 0, 1) + IF(ISBLANK([T3 Last Name]@row), 0, 1)) + IF(ISBLANK([T4 Last Name]@row), 0, 1))) + (IF(ISTEXT([Last Name]@row), 1, 0))), 0, "") If the cell has text I want it to count 1 - if not then 0 and…
-
Clone Worksheet to multiple Worksheets
Can I create one main worksheet and then have 20 separate worksheets? Each worksheet would got to a different person and only include their data from the main sheet. I would then just share their worksheet. I know I can do this with each cell, but would like to do this with the entire worksheet.
-
CountIfs Function for Daily Counts
I'm trying to get a count of records on a summary sheet, referencing another sheet that match multiple criteria by date, for multiple days. For example: I'd like get a count for all matching criteria for 03/18/2020, and then a separate count for all matching criteria for 03/19/2020, etc. This is formula I'm using, but I…
-
Connvert number into hour
Hi, I convert duration (in days) in to hour. Then I apply % of allocation to have a realistic working hours. By example, task with a duration of 11days, convert in 88 hours (8 working hours/day). If my % of allocation is 5%, the answer is : 2,8 hours. It's a decimal number, how can I convert it into real hours? The results…
-
IF Functions and Dates
Hi All, I am trying to use an IF function with dates. For example, IF a date is less than 15 days, return green, less than 30 days, return yellow and more than 30 days return red. When I tried typing this function in using the correct symbols and true/false values, I get an error message. I am creating a log of requests,…
-
How to fix my #Boolean Expected Error
Good morning, I'm trying to solve this error in my formula. All I want to do is display a % complete every time I click a check mark under my done column. Here is my formula: =COUNTIF(Done:Done, 1) / (COUNTIFS(Done:Done, 0, Tasks:Tasks, NOT(ISBLANK(@cell))) + (COUNTIF(Done:Done, 1))) Any help will be greatly appreciated!