-
Formula for Task Status using dropdown and Start | End dates
I'm trying to get a formula to work and I can't figure out what I've got wrong. Any help would be appreciated I would like to update a Task status dropdown field (Not Started, In Progress, Completed, Past Due) My formula is: IF(Completed@row = 1, "Completed", IF(AND([Start Date]@row <= [TODAY Helper]@row, [End Date (Due…
-
transferring specific row information to other pages based on drop down list
Still trying to learn how to make this happen... We have a master list (1st pic) where all RFQ information is input manually, when the selection of PO/SDR is selected from drop down, we want specific information to transfer to the next avalible line in Detailing department Sheet (2nd pic). Anyone have a suggestion or…
-
COUNTIFS to count late tasks
I am working in the SUMMARY for my spreadsheet. I have Summary fields that: total count of records (141) total the count of records completed (42) Total the fields that have dues dates in the past (99) Total the fields that are in progress (13) Given that 42+99+13 does NOT equal 141... something is not kosher. Thus I am…
-
Days without incident counter
Hello, I would like to put a Days Without Incident counter on my dashboard. I would like to count the days from the last incident (RED bubble in the Risk column) to today.
-
Combining ISBLANK and IF statement for two different columns
If "Start Date" is blank then I need to perform the following formula in the "Start Date" field: =IF([New Project]@row = "New Project (Next TYCIP)", "07/01/2024", "07/01/2023") This formula works but I can't figure out how to combine it with the ISBLANK. I get a circular error using this: =IF(AND(ISBLANK([Start Date]@row),…
-
Formula with severals needs
Hello Community ! i'm working on a formula to count how many machine of a brand have been sold. so i start with : =COUNTIFS(Brand:Brand, "YANMAR", [NEW OU USED]:[NEW OU USED], "New") this formula is working well. But i want to add specific conditons to my formula and this is where it's not working when i'm writing it. Can…
-
If Cell A is NOT blank AND Cell B is Not blank
I'm having trouble with my syntax I believe. I need to determine if Cell A AND Cell B are NOT BLANK then execute a function otherwise leave Cell C blank. The below is what I thought would work, however, I'm getting 'unpaseable' =IF(AND(NOT(ISBLANK([Case Product Removed]@row)), (NOT(ISBLANK([Case Product Re-Stocked]@row)),…
-
DAY Function
Hi everyone - I have 2 helper columns (Column Names: Apps scheduled for today and Apps scheduled yesterday) that is supposed to look at the create date and today's date to determine if a checkbox should be checked or not. Here are the formulas: Apps scheduled for today: =IF(AND(YEAR(Created@row) = YEAR(TODAY()),…
-
Can't get all IF AND parts of formula to work
Hi, I am creating a multi-part IF AND formula. Basically, I'm looking at two columns: Product and State IF Product = Science, assign to Mike Foster IF Product = Mathematics AND State = certain states, assign to Paula Smith If Product = Mathematics AND State = other certain states, assign to Bill Peace I've come up with the…
-
IF/AND/HAS for 3 column references, 6 options
Based on the content above for reference only, the actual sheet screenshot below. I need a formula or help with a helper sheet/workflow, to bring back one of 6 results. (above image) Tax Status Column is a dropdown with the 2 options shown, Bottling Location and Entity Columns are INDEX(COLLECT formulas (if it matters)…