-
How to get COUNTIFS to include selection within a "Dropdown List" of multiple values per cell.
Hi Smartsheet Support Community! I monitor the marketing and communications request for support log for our organization. We currently use one column to inform our team if a request needs writing, graphic design, or both. Whenever I use my COUNTIFS formula for graphic design, it isn't including the rows that have both…
-
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 <…
-
Automatically reference cell above, roughly 5 cells above will have a = from another cell.
Hi There, I was wondering if there was a way reference the cell above automatically, then on every x amount of rows have that automatically reference the cell to its right. We’re trying to do this so that we can create an autodate column essentially so when a new row is inserted it will place the date there from the locked…
-
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 ?
-
Column formula possible to count instances sequentially in an ever growing list
Probably a dream but, is it possible to have a column formula that would count, in sequence, the instances in a list. The first time a Name appears on a list would = 1 The second time a Name appears on a list would = 2 I have it solved with a formula but it can not be a column formula because of the variable piece.…
-
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.
-
I don't see the "automation" tab at the top of the sheet that I want to share
I've set up automations before using the tab in the left-hand corner but now I want to share a sheet on a weekly basis and the automation tab is missing. Is this because of the type of sheet I'm trying to share? Or is it the ownership? Or is it something else? Thanks for your help.
-
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…