-
Auto fill column with value from first cell in another column
I have an application where I use a header row to collect higher level project information, like overall project status, project start and end dates (as opposed to task start and end dates), etc. I copy rows from individual project plans to an "all projects" sheet from which we do some PowerBI reporting. I need a column…
-
Duplicate Check
Hello, If I would like to check Column A and Column B to see if there is a duplicate record, how would my formula look? In other words, when a new entry is submitted I want to see if the item and lot number are already on the file. Thanks!
-
What is the syntax for INDEX/MATCH from ranges on two Sheets?
I am trying to match data from two different Sheets into a third Sheet. I know vlookup will not work for this, so I am trying my hand at index/match and can't get the syntax right. How do you write a formula that can return results from ranges on two different Sheets?
-
Returning a date from another sheet using two criteria
I have two sheets, one being a Related sheet that has three columns: Number, Label, Date Then there is a Main Sheet that also has Number, Label, Date (plus other columns) This is simulating a One-to-Many relationship as the Related Sheet can have multiple entries for each Number which I want to collect into multiple…
-
Counting qty per specified type of condition
Hi All, I wanted to count the qty per type of Item description with condition that is filed as "request" in the column named "Type of request" ....how to do it? Example: I wanted to count the quantity of all "Prefab Aluminum Rack" with "Request" as Type of request. Thank you in advance. ;)
-
Trying to pull PM name from Intake Sheet when Certain Criteria is Met
I have tried a handful of different options, index(collect... index(match... tried each a few different ways. I either am completely missing something, or what I want I cannot do, and will need a work around. I have been editing the PMO Template, and am getting it where I need it. but on the Intake Form named "Shell…
-
Can a photo or attachment be shown in the report?
Is it possible to show a photo as part of a report? We are looking at producing to A4 size, as well as a dashboard. Dashboard is fine, but how about in the report itself? Many thanks as always! Vanessa
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
WEEKNUMBER FORMULA
I'm actually using this formula: =IF(AND(WEEKNUMBER([Start Date]40) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]39) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]38) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]41) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date]42) = WEEKNUMBER(TODAY())), "Not Available", "Available") to…
-
COUNTIFS with multiple criteria
Hello, I am a newer Smartsheet user and am learning as I go. I have tried several times to use COUNTIFS functions to count specific criteria from 2 columns in my source sheet, but continue to get the UNPARSEABLE error. (I also tried COUNTIF, then CONTAINS, but could not get that to work either. We are wanting to count how…