-
how to calculate capacity based on #days, %allocation and otoo request that is on a separate sheet
Hey Smartsheet Guru’s I have 2 sheets – 1 is capacity and the other is ooto – Sheet 1 – capacity has names and emails and %the first 3 columns and subsequent columns has week to week start date(as text), end date as text and number of days excluding holidays In the OOTO file – it is a simple if someone requests timeoff it…
-
Enable stacked bar charts built directly from Reports
When building a chart widget from a Report, Smartsheet currently only supports a basic bar chart. If I try to create a stacked bar chart from a Report (to split the bar by a second field like Status, CoC, Portfolio, etc.), it does not work as expected. This limits dashboard reporting because Reports are the cleanest way to…
-
Bulk add columns across multiple sheets and support viewing two sheets side by side
I manage a large number of sheets (100+) that share the same structure, and I often need to add one or more columns across all of them. Currently this requires opening each sheet individually and adding the column manually, which is very time-consuming. It would be extremely helpful to have a way to apply structural…
-
Highlight Changes Feature
When multiple collaborators are working in the same Smartsheet and the Highlight Changes feature is turned on and set to “I last viewed this sheet,” will the highlighted changes only appear for the first person who opens the sheet, or will each user see highlight changes based on the last time they viewed it? I am unable…
-
Bring data from source sheet in to separate columns in data sheet
I have a source sheet with >250 rows with each row having a unique [Criteria]. We assign [Status] and [Approval] status to each row that changes in a regular basis. Demo of source sheet: Given the number of rows, I would like to improve visibility of the changing status's in new sheet that will bring in the [Criteria] and…
-
Contact Columns ≠ Consistent Data
The Core Issue with Contact Columns Smartsheet Contact columns are fundamentally not reliable because they don’t represent people consistently. The same person can appear as a name in one place and an email address in another, depending on user status, permissions, ownership, or whether the data is viewed in a sheet,…
-
how long after you pay for 12 users will it be before you can add the users in?
The system just keeps saying "there was a problem."
-
Help button not working
Have any of you had a problem with the help button not working? This is the little round button that has a question mark in it. I have tried restarting and refreshing but still nothing happens. I am not getting an error message, it just isn't working.
-
Sum of values in a column within quarters
Hi All, I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of…
-
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.