-
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…
-
Reporting: Linking two sheets on a common column
In reporting I have picked two sheets. They have a common primary column name. The columns do consolidate (i.e. there is only one column with this name). But...I have two rows for each, i.e. row 1 is from sheet 1 and row 2 is from sheet two (of course, row 3 is from sheet 1 and row 4 if from sheet 2). Is there anyway to…
-
Anyone else's sheets not filtering since May 7th release
Our reports are no longer filtering on key fields like status and priorities. We noticed it on Monday May 9th and everything was working fine May 6th. Makes our reports contain alot of past items as now not filtering out complete tasks. Anyone else seeing their report sheets not working right this week?
-
smart change of column name
Hi, i need to change several column names in my smartsheet. I have entire workspace built around this sheet, using it as data source. I have multiple reports that show/filter on this column, and if i simply change the name, reports stop working. is there a smart way to update column name everywhere? or somehow get a list…
