-
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…
-
Counting Sub columns
Hello, I have a sheet that has category 1, then sub category 1, then sub-sub category 1. An example of the way it is set up is: Lunch (no indent) -Meats (one indent) --turkey (two indents) Dinner (no indent) -meats (one indent) --turkey (two indents) (hopefully you understand this example of how my data is set up) I am…
-
COUNTIFS to count the records that a date in a columns is before another date
Hello, i am struggling with this formula =COUNTIFS({Status_Arrival}, "SURTIDA", {FECHA DE ENTREGA REAL}, >= {FECHA TENTATIVA})) I want to count all the records in a sheet that meet the next criteria 1.-Status_Arrival = Surtida 2.- Real arrival date is before or in the same day than the expected arrival day. I try the…
-
Formula for a how to check a check box based on two ranges in two sheets
Hello, Can someone please help me with a formula that will check a box when it finds the email in both sheet. Master sheet has the Email Address and the box that needs to be check if it matches an email address in the BUP Survey sheet
-
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.…