-
Macro Functionality
Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows. My question here is as follows.…
-
Nested If Statement - help needed
I'm trying to get this formula to work. =IF([PRO Number]9 - [Trailer #]9 > 10), " PRO Levels: OK", IF([PRO Number]9 = [Trailer #]9, "Yusen Needs PRO#s"))) I want to trigger the IF/Then statement if the value of ([PRO Number]9 - [Trailer#]9) is equal to or less than 10. See screen shot below.
-
IF/AND Formula
I am trying to create a formula for when two approval columns have 'Approved' in their dropdowns to change two other dropdown columns. When "APPROVAL Status - BOB" = "BOB - APPROVED" AND When "APPROVAL Status - JOEL" = "JOEL - APPROVED" THEN "Approved?" column will change to "Approved" AND "Issue Status" column will change…
-
Formula help - adding criteria to LARGE?
Seeking some advice on how to make the LARGE function play nice with criteria and possibly, I'm thinking, the COLLECT function. Here's our set up: "Master project sheet" with: 1) "Project name" column 2) "2019 total hours" column which is a cross-sheet reference SUMIFS formula 3) "Project priority score" column which is a…
-
Sum if not blank
I am trying to sum across multiple columns but have it show blank if the columns do not have values. Each of the columns has a formula in them to calculate a number. However, I want the sum column to show blank instead of 0 if all of the other columns are blank. My formula right now is =SUMIF([Question 1…
-
Auto-hiding rows
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
-
Formula HELP - Trying to total cells that belong to specific market
I have tried several countif and sumif formulas but am at a loss. I have an expense report that has a market column (think departments) and a Project Costs column (total paid for the project). There are multiple markets to select from. I am trying to get a running total of project costs for each market. In simple form, my…
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
Need Help! RYG to update if Status = Completed OR % Complete = 100%
Not sure what i'm doing wrong here. I want the RYG column to show green if the status is "completed" OR if the % complete is 1. Please assist. =IF(OR(Status@row = "Completed", [% Complete]@row = 1), "Green", IF([End Date]@row - [Baseline Estimated Finish]@row > 2, "Red", IF([End Date]@row - [Baseline Estimated Finish]@row…
-
#INVALID OPERATION when dividing
I'm trying to do a count of how many staff have uploaded a particular document. I have who has uploaded the document and how many staff in total, and I want to display that as a percentage on the sheet. Whenever I try to divide # of Staff Uploaded by Total Staff I get #INVALID OPERATION. I've tried it both in formula and…