-
Change Management: Multiple projects > Consolidate into one
Hi there, I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so I'm trying to figure out the best way to organize them without listing them all out and clogging the other non-change…
-
Creating a formula that looks for criteria in a range and searches for that combo in a row
Hello, I hope I explain this the right way. I want to to find if a specific (row-level) combination of employee and date that exists on the first sheet also exists on the second sheet and if so, use a formula to flag the row that has the combination. For example, if Alex and 06/16/20 exists on the first sheet, I want to…
-
SUM IF Name and Points
I need to calculate the total number of points in the "Points Column" by each person in the "Name" column and I cannot figure out how its calculated. I tried to brainstorm with another co-worker and we both had trouble trying to figure this one out. Please advise.
-
How do I calculate IF statement to multidrop down list?
I can trying to get my sheet to calculate different values based on what is selected in the drop down. Example: If "Partner introduction" is selected populate 10 points in "points earned" column and $1 in the "dollar value earned" column, If "Quote Request" is selected populate 50 points in the "points earned" column and…
-
Roll up of assessment data with conditions
I need to be able to roll up associated transmittal #s to 1 Transmittal and if the assessment status is Not Compliant for any of the Compliance Assessments then Transmittal 1 should equal Not Compliant, Transmittal 2 = Not Compliant, Transmittal 3= Compliant
-
autofill of formulas is not working when adding more than one line of data without saving the sheet
I have a sheet with some formulas. If I add a new row of data ,the formulas are autofilled as expected. If I add another row of data, the formulas are not autofilled. If I save the sheet after adding the first row of data, the next new row will autofill the formulas. This means, I have to save the sheet after adding each…
-
Report on no activity
We have over 500 smart sheets for various processes. We'd like to know which smart sheets have had no activity for the day. Is there an way to create a report for this? Any ideas or suggestions would be highly appreciated.
-
IF/AND formula based on a drop down column if the cell is blank
Hi All, I am working on a formula to trigger my at- risk flag based on the following information. Raise the flag if the end date column is less that 1 day away and the status column is blank or Not Started. Here is what I have so far. =IF(AND(Status3 = "Not Started", [End Date]3 <= TODAY(2)), 1)
-
Formulas seems not to be calculated
I have a big sheet of ~11000rows by 30 columns (an asset register) I added 2 columns to calculate the duplicates =IF(COUNTIF([L2]$1:[L2]@row, [L2]@row) > 1, 1, 0) and to select the rows to show in a filter =IF(AND([DuplicateL2]@row = 0, NOT([L2]@row = "")), 1, 0) Copying/pasting or Selecting + CTRL+D the formulas has been…