-
Help with IF formula, #UNPARSEABLE error
Can someone help me please? In the “Queue” column, I have “mapped” from “ComponentID” column a list of values (using IF function), but now I must add to the existent formula the new value “ArtStation.” This comes from a long list of alphanumeric codes. All those codes start with “asset”, the problem is that I get…
-
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 <…
-
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"