-
Average or Average If with Sheet References
I tried using a formula created by the Generator, using cross sheet references to pull the data into our metric sheet, and received several errors. We would like to receive an average capacity percentage for an individual PM; the Generator provided the formula below, but if I inserted sheet references in lieu of column…
-
MAXIFS Formula to generate the latest date
I'm working on building a Smartsheet workspace for our facilities team to track recurring maintenance tasks, and have had issues finding a formula that works the way I want. For context, I'm hoping the end result will be comprised of: 1) a maintenance log 2) a maintenance overview sheet, which shows the most recent "Date…
-
Inventory Management
I'm looking to create a sheet to manage our department's inventory of swag/give-aways. I currently have the asset management template set up and running and am using the barcode functionality which is mostly serving our needs. The one gap I have is inventory updating. Ideally, when someone takes inventory, I would like for…
-
Count non-duplicate text cells
Hello everyone 👋, I want to count the number of non-duplicate values in a column with the text type. In this case, I'd have a formula such as =COUNTIF in the [Customer Requirement]:[Customer Requirement] range to count the non-duplicate IDs. As you can see in the screenshot above, I don't want header rows (Indent Level <…
-
Is there a way to have formulas populate images in a cell?
I have a column that has the name of a kind of rocket. What I want is to be able to do if "Rocket Name" is at row, add picture to different column in same row. =IF( Rocket: Rocket, " Falcon 9", Then add Picture in, Picture:Picture) I know the above is not correct but thats the idea.
-
Getting field value
I wanted to check if there is a way i can check on a certain column, if the value in the cell matches the value i need, provide me the value from another cell in the same row.
-
Referencing the Row Above in a Formula
Hi all! I am trying to create a formula that compares 2 values in the same column. One on the current row, to one on the row right above it. Every row represents a separate week, and I want to compare metrics from the current week, to last week, and based on the result (>,<,=) a symbol will appear. I found a post where…
-
Formula, IF Statement?? Escalation Status
I want to add a formula; The criteria is as follows: IF "Actual Implementation Complete Date" = BLANK AND "Target Implementation Date" is 14 (business days) (greater than or equal to) to than "Escalation Status" = "At Risk", otherwise "Overdue"
-
How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1
I am trying to create a formula that will Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value. There may be an easier or more straight forward way to do this but I am not sure. Below is an example…
-
Vlookup? Index/Match?
Need some assistance. Our fiscal months/years are a little wonky :). I have a sheet "Master Fiscal Year Dates" which provides the exact dates for each fiscal year, period, and quarter. In my accident tracking sheet, I need to pull in the Fiscal Year, the period, and the quarter from the Master Fiscal Year Dates sheet -…