-
Blocking users from moving rows while being able to edit...
Hi all! I use our smartsheet for a roll call log. I have employees moving rows and it's really screwing things up. I need them to be able to edit a column with toggles that say "here", "sick", "vacation" but not be able to move the rows. Is this possible at all? I cannot seem to find a workaround. Either the entire row is…
-
multi-select column not appear in report grouping
Why does a multi-select column not appear in Row Report grouping options in Smartsheet, and what is the recommended workaround?
-
Data entered on a Report doesn't trigger VLOOKUP based on the underlying Sheet cell contents, Why?
I have a VLOOKUP set up to pull a date from a cell on Sheet 1 to a cell on Sheet 2. The date will only populate on Sheet 2 if it is entered directly on Sheet 1. Filling in the same cell of a Report based on Sheet 1 does not populate the date to Sheet 2. I have instructed users to interact with the Report for ease of use…
-
Edit reports on a dashboard
Request We need an option for the report widget that would allow users to edit report rows while viewing them in the dashboard. The problem I'm trying to solve: I have a report widget on a dashboard that shows users their assigned tasks. I'm using the widget on a Dashboard to give the users one place where they can see and…
-
Dynamic View: Add configurable column width, spacing, and border styling in View settings
Idea Dynamic View is often used as a user-facing interface, but currently offers no control over layout or visual formatting (e.g. column width, spacing, or borders). Problem This creates a poor user experience — particularly for visually impaired users, where readability and spacing are critical. Columns cannot be resized…
-
Can I do a stacked bar chart of status types by week?
I've been asked to create a bar chart for a hypercare log like the one shown in the attached screenshot. The ask is to have a stacked bar for each week showing how many cases were active in a given week and how many were of each status (New / In Progress / Resolved / Escalated). The ultimate goal is to see the trend of how…
-
Add new filters in Report
Hello, I would love to have in my reports the possibility to filter on "This year", "Next year", and "Last year", according to a date type column. Today we can just define an date interval for example "after 01/01/2023", "before "31/12/2023", and it has to be updated every year. I hope some of you will vote this…
-
Creating a User-Specific Report by Project Requestor
Hi, We use Control Center. I have several user specific reports for people performing tasks. I figured it would be easy to make one for users submitting projects, but it's not working. Capture the data from requiring a form login, make a summary sheet report, set value to requestor. But no! It saves the requestor field as…
-
iCal to Outlook - Filtered Calendar?
I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible? I understand it can't be done from a report. I also…
-
Software Onboarding, Risks assessments, budgets, and more
Hello, I would like a sheet that can track software onboarding from the beginning to update and all the way to end of life. I have an excel sheet that I converted to a smartsheet, but I feel it's a very one piece modifying any data. Seems that it should be a very simple process that I have a blueprint with smartsheets and…