-
Is it possible to flag duplicates when the data starts with a 0 (zero)?
Hi! I have a sheet that tracks hundreds of cell phones, so it's really important to ensure existing records are updated rather than added as new rows. I can flag columns like Asset Tag and Phone Number with this formula =IF(COUNTIF([Asset Tag]:[Asset Tag],[Asset Tag]@row)>1,1,0) . The problem is that this doesn't work for…
-
Current Month Data Pull
Hello, I created a scorecard system to manage performance for our vendor base. I am attempting to pull a report of average rating within the current month. I was able to put a formula together, which is honestly intense, and it worked for the month of November, but as soon as December 1st hit, it wouldn't work. I believe…
-
Parent status based on children
This gets asked all the time and I've looked through posts but I can't get the formulas to work for my project. I have a project with hierarchy 1,2 and 3. I need the parents' status to update based on the children. My status options are: Not Started, In Progress, Complete and Blocked. If one child is in progress or…
-
Adding NETWORKDAYS to a formula gives #INVALID DATA TYPE
Hi, Happy Friday!! Please see below - I know I'm missing something simple. Any thoughts? I have a little formula that allows me to have a col formula and also have SUM(CHILDREN()). Date cols are both dates. Target total duration col is text / number. When I don't use NETWORKDAYS, I get the total duration as expected,…
-
Help with Formula Please
Hi, I am trying to find the formula so that the results show the total combined forecast amount but excludes any forecasted amount for an expected close date of 2025. Can anyone help please?
-
Week to Week % Complete Progress?
I have a % complete column in my project plan. Is there anyway to show progress on initiatives from week to week, for example, if we were at 30% last week and the report comes out and we’re now at 40% it shows in that box +10% or something?? I was thinking it will help show progress and if there is none, it could help show…
-
Formula to Pull out #s if they appear multiple times across different organizations
Hi, I'm trying to create a formula that will recognize and pull out any material #s that appear for different plants and make a new column with those material #s. I don't care so much if the material # appears multiple times for one plant, I only care if it appears for more than one plant. For example, Material # 1 appears…
-
Count Formula
My goal is to determine how many lines in a schedule that are actual task lines (not milestones). So I would need to count any line with the following criteria "Status" is listed as: Not Started, In Progress, or Complete "Assigned To" contains a name (or is not blank). Thanks for any assistance
-
Date based on the different cell values
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
-
Combine JOIN(COLLECT) and IF(AND)
I am trying to return specific text based on check boxes and want it to list if true. Apples| Apples 1|Apples 2|Apples 3| Apples 4|Apples 5| Apples 6| and so on... I have check boxes under each Apples column where people can select which Apple they want. In the Apples column I want to return a list of their selections like…