-
Count Blanks from Referenced Sheet
Hi all! I am attempting to count the Blank cells in the 'Assigned to' column of another spreadsheet and have it not include the blank cells at the bottom when the rows are also blank. This is the formula I'm using now, but it is counting those blank cells/rows at the bottom of the reference sheet: =COUNTIFS({Deposit…
-
Formula broken on one sheet but not broken on others?
Hello Smartsheet Community! I have a formula that is acting up on one of our sheets. We use a budget sheet that is standardized across multiple Business Units and one of the sheets is currently throwing an #INVALIDVALUE error with the below formula. =IF([PO or CC]@row = "Purchase Order", SUMIF([Salesforce…
-
Formula to subtract one month from a date
Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say 4/1/20, I'd like the first calculation to produce 3/1/20, and the next row to produce 2/1/20, and so on. I did find a…
-
Multi selection form into single rows
Hi all, I have a form that allows multiple selections. Once the form is submitted I need the each selection to be added as a new row. I have several issues: -Selection list extensive (50+) therefore cannot be written as separated columns as suggested earlier. -Users will have a hard time to submit a form for each item and…
-
split a multi-select form response into multiple rows
Apologies if this idea has already been submitted. I've seen several people post this in the discussion forum, but did not notice posted as an idea. It would be amazing, if Smartsheet had a way to split multi-select form responses into multiple rows, without a complicated formula or the need to use a 3rd party.
-
COUNTIFS formula kicking back wrong number
I'm looking to get the total number of docs submitted that had an error, so a row count of items that aren't 0 in the error lines column based on Indexer Identifier Number and the formula I made works, but it kicks back 5 instead of 2. I'm not completely sure what i'm missing in the formula to get it to kick back the…
-
Sum Multiple Drop Down Selections
I have a Smartsheet with a drop down cell that I can select each employee working on a task. Each employee has an efficiency rating from 1 to10 on another sheet. I want to be able to sum the ratings for each crew into a single cell. I have spent hours looking for a formula to do this with no success. I appreciate any…
-
Sheet Analyser - What would you like to see?
Hi, I'm creating a sheet analysis dashboard with the API that will provide a detailed breakdown of any issues on a Smartsheet sheet, so that admins can improve their sheets and head off any potential issues. Some of the things I've already added warnings/information for are: High row, column and cell counts Broken formulae…
-
Counting occurrences of drop down menu selections
Hi all, I'm looking for a COUNT or COUNTIF formula to total drop-down menu selections within a given range of cells in a column range. The attached shows the DD menu with trusses selected. Our sheets are broken into calendar months, sometimes with over 100 entries for that month. Not every cell within that column has…
-
Formula history is now viewable in Cell History in table view
February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…