-
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)
-
I.T. Project Management workflow process
Hello, I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk drives. I have information on an excel sheet that was provided & an initial Smartsheet…
-
dropdown multi-select and lookups -- vlookup, join, collect, index, match???
Hello, I'm having trouble understanding what function I should use to do lookups when there is more than one matching value. I know how to use vlookup, at least well enough to know it won't work in this case. Here's what I'm trying to do: On one sheet (sheet1) I have a dropdown multi-select with about 80 different options.…
-
Is it possible to look-up information from a different sheet with more criteria?
Hi all, hope everyone is doing fine here. I'm working on a sheet to specify information from a larger sheet. I was wondering if it is possible to vlook-up information with more lookup values? Hope you can help me out! Jordi
-
Countif with Dates and Criteria
I am trying to do a count of a symbol (red dot) by each month. I have a column for the month "Date" and four columns (Missing Mentoring Form, Missing Training Course, SharePoint Error, Skillset Does Not Appear on Training Matrix). When there user selects a drop down to red i would like it to be counted. I have that running…
-
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…
-
How can I pull a report- or write a forumula to show me Rows with a specific status?
I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Status for EACH team member. My goal is to be able to facilitate compliance by providing…
-
If formula for RGYB balls
Hi All, I want to create a column so when i change the colour of the ball it changes to a set word. So Green will say "install" for column 7 Red will say "work needed" for column 7 Yellow will say "At VC" for column 7 Blue will say "Back from VC" in column
-
Column Reference Formula Returning Incorrect Answer
I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that are not installed or closed to determine how many are "in process". This formula which…
-
Copy INDEX formula down for the rest of the column
Hi all, I want to autopopulate the first column of sheet B with the data from the first column in Sheet A I got it to a point with using the INDEX formula to reference, but now I cannot drag the formula down to apply this for the entire column. This is for row 1 "=INDEX({Sheet A MUR TN}, 1, 1)" I think I am missing…