-
Is it possible to create uniquely identified numbers using level 1 parent tasks as a baseline?
Is it possible to pull the first three letters of a parent task, and then give it an unique identifying number xxx-9999? I have groups of tasks that I would like to create an ID for whenever there is a newly created line, each line would inherently be a child to parent task. For example a subtask of an "Engineering" group…
-
LEFT Function
I want to add a "0" to the left of any number with just 5 digits and just duplicate any number with "H" in front.
-
Querying my sheet
Hello, i have these two columns: ESTIMATION PER HOUR (number) RESOLUTION (numbers) I want to query the sum of all ESTKM2/H matching if RES=5 and divide it by the number of items matching this query. In the end i want to calculate the mean of estimation among all resolution 5 jobs. The result would be something like= the…
-
Getting an image approved - how to set Approval Status from multiple cells, ignoring blanks
Hello! I have an image production process sheet that at the moment requires 1-3 approvers per image. The images to be approved live in a cloud drive - they do not get attached to the Smartsheet. Basically, when there is a contact email in an Approver cell, I need a formula to check what the Image Approval Status is. Here…
-
Cannot calculate checkbox column
I am trying to calculate the number of checked cells in a column (named 'Done'), however I keep getting errors! The checked ('Done') column in question is pulling from another sheet using index links so will throw up a tick in the check box and a #NO MATCH accordingly. The calculation i am using to pull from the checked…
-
How do I create a formula that covers two sheets ?
Hi, I currently have this formula in use and I'd like to include one more sheet. How do I do that? Thank you! =COUNTIF({Master Data - National (Atten how did you hear)}, Label14)
-
Formulas with reports
Hi, I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report. When I build the formula, the report is not an option in the list. Please advise. Thank you!
-
Conditional Import from "Master" Sheet
I have a "master" sheet called "Verified Content List." This sheet contains about 600 rows. Each row contains metadata for a specific assets. A column in that sheet called [Content Type] identifies each asset's type (e.g., Data Sheet, Ordering Guide, Battle Card, etc.) The list is updated once per week via Data Uploader as…
-
Index/Match, Collect, or Vlookup
I am trying to pull dates over from another sheet and matching on a unique value that is present in both sheets. However, the source sheet has the same unique value repeated multiple times and I want to return the date that IS populated. 1) {Schedule - DRL CMP WEQ Range 3} : this is the source range that contains the data…
-
SUMIFS not recognizing criterion when it is a formula
Hi, I have written a few simple SUMIFS that use the current month or current year as the criterion. However when I combine the RIGHT function in the cell with the criterion, the formula returns $0 (it should return $200). If I manually type 21 and set this as the criterion, the SUMIFS works. If I use the same formula and…