-
Inventory - How to let multiple users claim an item without seeing others' selections?
Hi All, I'm in the process of building an inventory type system in Smartsheet for my company. I have one sheet that tracks inventory for each location. I'd like to have it so I can show employees inventory for their respective location and then if they want an item, click a checkbox and I record their responses. I do want…
-
Merged: Include RM (Ringgit Malaysia) in the currency list
This discussion has been merged.
-
Merged: Sort/Filter by conditional formatting rules or cell colour
This discussion has been merged.
-
Work Breakdown Structure (WBS) - Column Formula Configuration
Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in case some may find it helpful in executing project management solutions, this…
-
Add Hyphen Checkbox schema to help with tracing a sheet to its location within a Workspace/Folder
When a user clicks on the "Sheet" button in a report to find where the source sheet(s) is found it is extremely hard to locate which workspace/folder the sheet is located within. It would be extremely helpful to use the UI design Smartsheet already uses when less then all items within a folder are selected; a hyphen in the…
-
Index Match with multiple Parent/Child rows in a sheet.
Hello all, I'm looking for some advice on a tiered IF statement using index/match and CHILDREN formulas. My case: I receive numerical data from another metric sheet that copies it snapshots into this archive once a month. There may be times where we need to edit the historical data. To ensure the % columns are updated I…
-
Merged: Automated Deleting of Old Data
This discussion has been merged.
-
Dashboard
I have a dashboard roll-up sheet that is using a COUNTIF =COUNTIFS({sheetname}, [Column2]10) formula to count the number of cases an employee has. I know the employee has cases on the sheet, but the field shows zero, instead of the number of cases that are assigned to them.
-
Dropdown multi-select columns list comparision
I have two columns that are dropdown multi-select. One column includes a list of all possible values (example: letters A-Z) while the second column includes a list of some letters (without duplicates (example: A, B, C). I would like to create a column that displays the missing letters (example: D-Z). How would I go about…
-
How can I get a multi-select dropdown column to populate with comma separation?
I have a two different columns that are populating differently, just using simple formulae: (I took out all the error checking to make it simple until I can get it to work) =[Name]@row, where [Name] is a Contact list, allowing multiple contacts per cell, and =[Department]@row, where [Department] is a Dropdown list, also…