-
Is it possible to default to the calendar view rather than the grid view?
I set up a conf room reservation system using a report on top of a smartsheet. I've shared the URL with end users but sometimes when they follow the link it displays in grid view when I only want it to display in calendar view. Sometimes its correct and sometimes not which is causing headaches. Is there a way to force one…
-
Printing a row & consolidating data
Hi, I use rows for individual marketing campaigns and tracking progress across columns. When I close a campaign, I'd like to print off a report of all of the data in that row. Each job has about 55 columns of data. Is there an easy way to print off a report of all of that data without it being presented in a row, visually?…
-
Complaint / Poor Design: Blank Reports
I've just learned reports shared with users who are not also shared to the sheet (or sheets) that contain the base data cannot see the reports due to "security issues". This is - in my opinion - a seriously poor design. If Smartsheet can't secure a sheet / report relationship in this manner, what's to say anything can be…
-
Updating a reports format from the related smartsheets
I have a report that looks at 30 smartsheets for current task status. On each smartsheet I have conditional formating to change the complete lines color based on a date field and the current date. When I run the report and I know a line should have chane color but hasn't, I open the related smartsheet and the line color…
-
Linked Resource Allocation Overview Sheet
I'm trying to create an automatically updated linked overview sheet to help my team to better visualize how their task assignements on various projects sometimes overlap. The resource views provided by the Smartsheet Resource view are just not that easy for the team members to parse and so they never use it... The "angry…
-
Web Form Functionality
Greetings All - I am just shy of completing the academy but I do have a question to complete a project I am working on for a company. I would love to utilize the web form option; is there a way that columns, rows, and fields be manipulated in any other way? Adding fields are fine but that just adds columns and not…
-
Report showing sheets I've shared and to whom
Our team is fulling engaged in using - and sharing - Smartsheets. The reporting capabilities are terrific. But I am trying to locate (unsuccessfully) if there is a way to run a report on all the sheets I have shared and, specifically, to whom I have shared all those sheets. Rather than clicking on each sheet separately and…
-
Pre Configure Report (Task list) for each Resource that will work on Project
Hi, This is probably a Feature request rather than a discussion as I do not feel that there is a way to do it at the moment, but I may be wrong. I would like to create individual reports for each of the resources U am going to use on the project. The Criteria being Assigned to (Contact Column) that resource. Problem,…
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Report by User logged in?
Is there a way to create a report that filters the underlying sheet by the user running it? For example in SharePoint, you can create a view, so that whomever is viewing it will see just their records according to a column by entering a filter in the view setting the column to equal [Me]. Is there something similar in…