-
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 <…
-
Duplicate values identification
I know the way to do it for a small table =if(countif([C1]:[C1],[C1]@row)>1,"Red","") But that cell reference all the cells in C1. It get to a huge number of reference quickly. I've reached the 250 000 limit with that and around 4k rows. Is there a different way that use less cell references ?
-
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 -…
