-
COUNTIFS FORMULA REFERENCING ANOTHER SHEET HELP
Hi Guys, I have been trying to figure out why my formula is not working. I am referencing a sheet named LATE VENDOR DELIVERIES and looking at the columns in that sheet LOCATION # AND NAME and also CLAIM STATUS. I don't see where it references the other sheet in my formula so not sure if that is the problem.โฆ
-
Check if today is between set dates yearly
Hi, Is there a way to check if today is between two different dates? The day and month will be the same every year. I need this to check if our cars have the correct tires for the seasons.
-
SUMIFS with Multiple Criteria and OR function
Hello, I am trying to count the number of "sites" in Site Count that have a Projected Contract Sign Date in "Q1-2022" that are a Type of either a "Migration" or "Full Install". Can someone please review my formula below and advise? I am receiving #UNPARSEABLE error message. =SUMIFS([Site Count]:[Site Count], [Projectedโฆ
-
Networkdays Error - Dates used in cross sheet references
I get an #INVALID DATA TYPE error for this formula: =NETWORKDAYS([Baseline Finish]@row, [Planned Finish]@row). The Baseline Finish and Planned Finish date columns pull these dates from a different sheet using cross-sheet links. Any suggestions?
-
Counting cells with specific data
Hi, I am trying to count the number of cells containing criteria entered using a drop-down box (via a form) in a 'Covid-19 Vaccine Status' column, but I am only wanting the data from rows where another column is blank, that column is called 'Finish Date'. I also want the cells that remain blank in the 'Covid-19 Vaccineโฆ
-
ISBLANK, IF, AND combination
Hello, I am trying to get the below formula to work however am not having much luck. =IF(ISBLANK([Customer Owner]9, 0, IF(AND([Start Date]9 < TODAY(), [End Date]9 > TODAY()), 1))) I would like a check box ticked if the [Customer Owner] is NOT blank and today is between the [Start Date] and [End Date]. TIA
-
Manpower Availability and Scheduled
Hi, I need assistance with setting up a sheet showing manpower assigned to a job and/or manpower available. Example attached. We have one sheet that list each project and we then assign crew members to each line/job. There could be multiple crew members assigned to one job (line) I want to be able to look at a Manpowerโฆ
-
Children sum formula total calculations
Hello everyone, I have a formula issue that has stumped me. My use case is basically summing up all of the Job income per quarter. Our jobs often have differnt phases which are simply indented to the job itself. My primary Job rows are set to =SUM(CHILDREN) while the total wrap is just set to =SUM of all rows. Myโฆ
-
Date Formulas
Hi all, Attempting to create due dates for types of tasks within a grid. I will settle for a formula that adds days. But would really love to create automations based on selections made in the types of task column. Please help๐ฌ
-
#invalid Datatype Error
Hi all, I've a formula to calculate estimated hours. =SUMIFS({Master Summary - Estimated Hours}, {Master Summary Rollup | Live Date}, YEAR(@cell) = [Year Helper]@row, {Master Summary Rollup | Live Date}, MONTH(@cell) = [Month Helper]@row) The formula uses two references to a Master Summary sheet. Estimated Hours (fromโฆ