-
Formula changes without showing in Activity Log?
I have this formula: =IF(ISBLANK(Location@row), "", INDEX({Location_code_helper Range 1}, MATCH(Location@row, {Location_code_helper Range 2}, 0)) + "-" + RIGHT(Year@row, 2) + "-" + COUNTIFS(Location$1:Location@row, Location@row, Year$1:Year@row, Year@row)) It basically creates a custom identifier that uses the year and a…
-
How to COUNT multi-select drop down list.
My sheet is for process improvement ideas. When one is finished, we have a column where we can check off which areas we improved (some are just Cost Savings, some have 3 or 4 options selected). I'm trying to count how many times each improvement category is checked off on the entire sheet. Note: I have 5 categories, for…
-
Count cells with specific values in row with matching ID across sheets
Hi, I have the following requirement: I have 2 sheets, each with the [Project Number] column as the ID. Let´s call the sheets [Intake Sheet] and [Picking List] The [Intake Sheet] holds, for example, a range of 10 columns in which machine part names are entered. Let´s call the columns [Machine part 1] … [Machine part 10]…
-
Calculating costs for tasks with multiple assigned reources
Hi, I am using the following formula to calculate the effort costs for a task. It references a list of resources with allocated rates. For a task with one resource assigned, this work fine. =[Effort (hrs)]@row * INDEX({Rates}, MATCH([Assigned To]@row, {Names}, 0), 6) However its not good for tasks with multiple resources…
-
COUNTIFS WITH DISTINCT
HI Everyone, I am trying to calculate the distinct values in column Contain using countifs and distinct however i need the range of contain to be included in the range. Column7,8 week3 will be my source chart. COUNT(DISTINCT(COUNTIFS()))) i've tried using this but i can't incorporate the "contain" column, would you…
-
Formula for using RYGB with certain criteria
Hi All, Hope you guys can help me out. I'm trying to set up a formula where it looks at 2 dates and a checkbox and return certain outputs based on whats filled in. So the main outputs should be: If Date 1 is empty and checkbox is empty = Blue If Date 1 is empty but checkbox is checked = Green If Date 1 is filled and…
-
How do I count only the top level Parent Row
HELP...I am so frustrated. How do I count only the top level Parent rows not all Parent rows. I have added a helper checkbox column and have used the following formula. =IF(COUNT(CHILDREN([Task Name]7)) > 0, 1) This works great as long as there is only one level of Children. But as soon as I add sub parent rows they become…
-
Find the sum of a number string contained in a series of numbers
Hello! I am currently trying to find the amount of times the entry @row in [Med ID's with space] can be found in the entire [(Cell Linked from TE Tracker)] column. Then I would like the sum of the [Excursion Time (min)] of all the [(Cell Linked from TE Tracker)] cells that the [Med ID's with space]@row was found in. As you…
-
Retrieving previous status to show on Dashboard
I have a Status Update worksheet. And what I'm trying to do is show the current update on a project dashboard and want to show the previous update to the dashboard as well. How can I automate this so it automatically will update my dashboard whenever I make updates to the Status Update worksheet?
-
Formula Help
Hello, I am trying to fix a formula that only partially works. Any help would be greatly appreciated. I have one column, labeled Account# with various drop-down options, multi-select. I have a second column labeled Multiple Accounts that is a checkbox column indicating when 2 or more accounts have been selected in the…