-
Sum of each Dropdown Option Selected Formula Help
Any Suggestions on the simplest way to formulate this? * Dropdown Column - "Part Status" * Dropdown Options - "Delayed" "Not Started" "In Progress" "Warehouse" "Shipped" I want to show a total sheet sum for EACH Dropdown Option shown. Part Status is only selected on the Parent Rows. Rows 4-287 with 30 Parent Rows. Thanks…
-
Notification when new State is added to list - unique list
Hi, I need to create a notification when we have an order shipped to a State we have not shipped that product to in the past. The client's State is automatically added to the sheet from a workflow, and I need to get notified when ever we have a new State added to the list. I think one way to do is this is to create a new…
-
Row ID
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or the current row. If there is no ancestor, I assume it would then return null or 0 Does a function such as 'ROWID' or similar…
-
Nested IF Statement Limit?
Is there a limit to the number of nested IF statements in a formula?
-
Simplifying my formula
I would like to simplify a formula (if possible). Several items in the formula below have the same value (e.g. 25 or 10). =IF([Activity_1]1 = “JTA”, “25”, IF([Activity_1]1 = “IDW”, “25”, IF([Activity_1]1 = “Lab Builds”, “25”, IF([Activity_1]1 = “TR”, “20”, IF([Activity_1]1 = “VCDX Def”, “15”, IF([Activity_1]1 = “VCDX…
-
Run report for current month
Let's say my task sheet has dates that tasks are created - not necessary TODAY. And I want to run a report if the created date is this month. For example, Task A's created date is 09/10/2017, and this month is September. The report should pick up Task A if I run report today, but next month. How can I achieve this? I made…
-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Adding to an Existing Conditional Formula: Date Field
Good Day All: I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green All help greatly appreciated, Thanks! Existing Formula: =IF([Approved by Committee]2 = 1,…
-
Help with a formula
Greetings, First time posting because I'm not well versed with formulas and I'm hoping that someone smarter than me can offer some guidance. I would like to create a form that assigns a point value to specific activities (e.g. JTA, IDW, SS, TR and so on) identified in different columns and sums the total value of all…
-
Using LOOKUP function on a sheet with a form to add rows
I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that the LOOKUP area shifts as new rows are added. I set all my lookup tables at the top of a sheet and then the new rows are…
