-
Master sheets - why sheets and not reports?
New to SS. Setting up many project sheets and then want the high level info pulled together onto a master sheet. Videos I've watched say to create a master sheet and link data in from project sheets. Project management webinar I watched has a company that designs/fabricates/installs 10,000 signs per year (complicated…
-
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights…
-
Publish Links - Private mode only
I love the option that allows you to publish a link and display in html. However, I cringe at the thought of this being visible to anyone. We do not want our competitors or unauthorised users to peek at our projects. Is there a way to control who gets to see this published page? Thanks, Peter.
-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
-
Shared Report - showing blank
Hi there, I've got a report shared that essentially allows someone eyes onto a sheet if 1 of 2 conditions is met. One is a dropdown box and the other is a checkbox. This person is able to open the sheet, and it shows the column headings correctly. But the info itself is not populated - totally blank. I've shared it to…
-
highlight changes in report format disappears in sights
Hi, i have a report, and in it i have "highlight recent changes". works lovely. but when i show this report in sights, the highlighting disappears, even though the rest of the format is there. is there a way to leave highlighting in sights? thanks
-
Reporting When a Sheet was Last Updated
As we struggle with user adoption we are trying to find a way to understand who is and who is not updating their sheets within SmartSheet. I have tried a variety of user reports and system reports, but not seeing a lot that can help with this. At the end of the day we are just trying to see that a sheet had an update done…
-
Customized Sheet Properties
I have a situation where our organization will be creating all of our project sheets through one group. This means that the project owners will be out of sync from who actually is the owner. In addition to this we would like to filter by certain project level items such as Implementation Status, Project Health, Escalation,…
-
Filtering on name
I am struggeling with fitering on name when generating reports. The filter in the report refers to the e-mail address of the user while the entry is the affiliated name. E.g I am not able to sucessessfully use negative filtering eg. show all that is not christopher.grinde@ge.com since the entry is Christopher Grinde.…
-
Sharing Filtered Gantt Charts
I want to share a filtered view of a smartsheet (gantt chart enabled) that shows: * dependencies and parent/child relationships that the user can close and open to help them focus on what they want. If I make a report out of it, I loose the parent/child functionality and the dependencies aren't displayed. I'm resorting to…
