-
Work Insights Data
Hi, Trying to utilize Work Insights to show our statistics, but it's currently showing incorrect information. The sheet that it's on has been updated with the correct information for over 24 hours so that shouldn't be the issue. It's showing the incorrect info from the Column Snapshot, but it will show the correct info if…
-
Import Excel Workbook as Workspace or Folder
Currently, the import function only allows importing one sheet at a time. An easy solution to accommodate workbooks with multiple sheets is to allow them to be imported as a new workspaces or folders, with 1:1 sheets.
-
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.