-
Assistance rolling up data to a master sheet
Hello, I’m trying to create a roll up for multiple resources across multiple sheets. I would like to have data roll up like how it looks in the Resource Allocation, but I’d like to view allocations in hours rather than percentages. I've attached an example of a project schedule in SmartSheet that we use. I thought that it…
-
Listing text values from multiple rows in a single column, to a single cell
I am working on a master sheet for safety across our company. I have multiple rows (each specific to a particular project), of which there is a column for subcontractors who violate safety protocol (linked to a project-specific SS). Is there a particular way or formula that can be used to take all of the text from each…
-
Chrome app closing without a warning
Hi all, When I run smartsheet in chrome browser, if I try to close the tab and there are unsaved changes, I get a warning about that. However, when I use the chrome app, if there are changes to be saved and I close the app, then it closes without any warning, and hence those changes are lost. Is there any way to fix that…
-
Auto populate worksheet through hyperlinks built with web forms
My objective right now is optimizing my worksheets to have as little human interaction as possible beyond entering inputs. To that end I have users input their data through web forms to populate my sheets. My issue is that I cannot generate hyperlinks automatically on the new rows created by the web-form. I have…
-
Colors in Workspaces
Hi, I have one set of custom colors for our entire site and a second set for a specific workspace. When I'm viewing a sheet that is in the workspace, all the tabs for currently open sheets turn that color, even if they aren't part of the workspace. When I'm viewing a sheet that is not in the workspace, all the tabs for…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Sights and Auto refresh rate
Hi, I have a client that wants to use Sights as a Dashboard on a Large Plasma in their office. They want the Dashboard to auto update/refresh without human intervention. Is there an Auto Refresh rate setting (Not seen one) I am looking at a Chrome extension called Super Auto Refresh. Has anybody got experience with this…
-
Enhancement Request: Show and allow edit of Working Days when Dependencies are disabled
When working days are set (either by SysAdmin for new sheets or directly in the sheet) and Dependencies are disabled, the dialog implies they do not impact the sheet. But they do. I posted about this today: http://ronin-global.com/2017/06/23/smartsheet-using-working-days-without-dependencies/ Since they impact the sheet,…
-
Enhancement Request: Provide Highlight for differences using Data Validation
When setting data validation on a column (ie Dropdown type), a warning is provided to warn user there are differences. As an Admin, user can allow these. Provide some means to flag these differences. Moving to a validated column with 25 choices there may be dozens on typos or more in the old data. An easy way to find them…
-
Comments on 2017-06-20 release
https://www.smartsheet.com/release-notes (2) In-Line Formula help Please allow means to turn off the feature (not turn it off after it shows up). If I realized it was always on when I was testing it, I would have said something then. I don't need to see it every time, so default to collapsed is preferred. I often need to…
