-
If Statement to calculate date
Termination form: Termination Date captured in [Term Date] [Duration - Phone/Email Forward] single drop down selection 0 days, 30 days or 60 days I would like a [Disable Forward Date] to be generated based on selection of [Duration - Phone/Email Forward] Here is my attempted formula/function- =IF([Duration - Phone/Email…
-
Stop the clock
I have built in a daily counter into my sheet. I am trying to figure out the best way to automate stopping the counter when a certain value is selected in another cell. I have thought about transferring the data to another sheet but I have other fields on the same row that are dependent on the data in that specific cell.
-
Text to Date Field
Hi, I've been looking at the community board for a formula to convert a text date (ie. 05/21/21) to a DATE type data entry in a new column. Any suggestions? Thanks, John
-
Formula working in some cases in my sheet, not in others
Hello! I'm trying to write a formula to count and compare how many new clients an individual staff member managed to get over the line in a given month. I'm experiencing an odd issue where in certain places in my sheet, the formula is working, but in other places it's not. So for example, this one is returning a number no…
-
Counting Checkboxes + Date Range
Hi, I am currently trying to count the amount of Covid Cases and have it report every Wednesday. For example, I need the total number of Covid Cases from 1/5/22-1/12/22 (so the report to show a weeks worth every Wednesday). I have it setup that if someone is Covid+, they check a box. I have the formula to count the Covid+…
-
need a formula to return the number of forms filled out by a person(x) with a score of x
I need a formula that will return the total number of forms filled out by a specific person with a score of 5. It is cross sheet references and I am stuck. I have found some saying vlookup or countif. Butt neither formulas are working.
-
SUMIF row is in the next 5 working days
Hello, I am trying to create a formula that counts the total size (EQA) of the jobs that are due in the next 5 working days. I am using this formula but it's coming up with 0 =SUMIFS(EQA:EQA, [Delivery Date]:[Delivery Date], ISDATE(1), [Delivery Date]:[Delivery Date], NETWORKDAYS(TODAY(), TODAY(7), 0)) Any help on this…
-
Counting # of rows that match a number range
I am trying to create a sheet summary formula to count the number of projects that are within a number range (# of days out or past). I am not sure what function or formula to use but I created a formula like this that isnt working: =COUNTIFS([# of days to Finish Date]:[# of days to Finish Date],=>0,([# of days to Finish…
-
Formulas
I have a report where I track estimate by project manager. I would like to count the estimate that need follow up that are past due for each project manager. I keep getting an unparseable error =countif([Number of Est]@row,{J&B Estimating Log Range 5},=<TODAY()) "Number of Est" is a reference to the sheet I am working on…
-
Calculating Time difference between Auto Generated Date/Time and Manually Entered Time column
Hello, I currently have a form that collects a small sample of data and then generates a row on a sheet, and that row has a "created" column using the auto generated date/time stamp. Someone completes that task and then marks the row "Approved" which generates an approval DATE and then they manually enter a time stamp…