-
How to maintain permanent inventory levels when source data is deleted weekly
Hi all, I am looking for advice on the best workflow to manage inventory deductions. I currently have two sheets where Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a…
-
How to maintain permanent inventory levels when source data is deleted weekly?
Hi all, I’m looking for advice on the best workflow to manage inventory deductions. I currently have two sheets: Sheet 1 (Master Stock List): Contains hundreds of items, locations, and catalog numbers. Sheet 2 (Weekly Usage): Operators log items used during the week by scanning QR codes. Currently, Sheet 1 uses a SUMIF…
-
Formulas in Reports - Any way to speed up?
Currently, I have a report connected to a single sheet. This sheet contains various formulas, including cross-sheet references. When data is added to the report, the formulas will not update/work unless the sheet is refreshed. Is there any way to have the formulas values "pop-up", or otherwise load? It is somewhat…
-
Revert the Workspace Browe Bar
The new browsing function makes it difficult to see and sort through multiple workspaces and sheets at once. Though there is a way to temporarily revert the workspace browse bar, there is not a permanent option. We would like for there to be a permanent option for those who dislike this change to be able to revert their…
-
Workspace Sharing Question
Hi Everyone, We currently have a Smartsheet business plan and we wanted to know if it was possible to invite people into workspaces, but limiting what they see in the workspace. A few users would like to be able to edit some sheets within this workspace, but it is not allowed since their accounts are set as viewers. Is…
-
Delete functionality
Bring the delete functionality in automation, this can be helpful if we want to delete a specific row based on certain conditions. this can also have a timeline based delete option that can be set in the sheet level setting
-
I have lost access to my sheets after a license change. How do I get edit capabilities back?
I have recently moved from a business license to an enterprise license, and now all of my sheets I created are set to view only. I have validated that I am a Member under the new enterprise license, I am owner of the sheets, and I am in the correct region that my sheets are in. However my sheets are still view only. How do…
-
Gantt Chart Auto-Scroll
Idea: Have the option to sync the horizontal scrolling of the gantt chart with the vertical scrolling of the grid sheet.
-
Automating date tracking and reminders
Hello, Im building a long-range fiscal quarter date tracking sheet with preloaded due dates over multiple years . I need reminders to notify the assigned person only when the item is active , still unsubmitted, and within 30 days of the due date. I also want to avoid excessive reminder frequency. Also i want to generate a…
-
Conversation and Attachment Indicator at the Sheet Level
Color code or indicate when there is content in Conversations and/or Attachments (Icons) at the Sheet Level. This would eliminate clicking on the icon to see if there is content to view. See attached for an example.…