-
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…
-
COUNTIFS of a text string based on a condition
I have two text columns. One column contains titles of documents. The second column contains specifies the document's "category." One of the categories in the "Category" column is "Presentations." However, in that category are two different types of presentation: "BDM" and "TDM". Whether a document is a BDM or TDM is…
-
Automate RYG Balls Based on Two Different Dates
I am trying to create a formula that looks at two different start dates to set the project status. It looks at the first start date to see how far out (TODAY) is from that date and looks to see if there is a date in the second start date. This is what I have so far: =IF(AND([Start Date]17 >= TODAY(+28), ISBLANK([Start…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce