-
Help creating a
I have 8 Smarts heets that I want to roll up into a report. Each represents a different project and they all have the same columns. I followed the video steps to create a rolled-up sheet with date/contact etc. details but I'm being told when I try to do so that the "rows can't be found" Can someone provide some assistance?…
-
Gantt to Grid Report view
I have many projects (let's say 20) all with the same many tasks (Let's say 20 again). The Gantt view is great to handle predecessors and additional information associated with each task. However for a project status meeting I would like to view a report horizontally, see image attached. Is it possible to make a report…
-
How to manage resource loading from a master sheet.
Hello, I trying to create a master sheet of a set of projects in order to help with resource loading questions. I can easily create a report that displays all the tasks for employee A vs employee B. I can create a report on all tasks across all selected projects with employees A-E. However, since we cannot use formulas in…
-
Automated Email Reports (not emailing out a re-occurring report if the content is blank?)
Is it possible for an automated report to not email out a re-occurring report if the content is blank? Currently I am using a report to pull a list of milestones that are past due. If there are no past due milestones is there a way for Smartsheets to recognize that and not send out an email?
-
A sheet with links to all my SmartSheet Objects
I am looking for a way to inventory all the SmartSheet objects I am associated with Columns may be Object Type- Sheet, Report, Dashboard, Dynamic View, etc Object Name Workspace My role- Owner, Admin, Editor. etc Link to object
-
Report on All Workspaces
I would like to create a report that shows all tasks assigned to an individual across all projects. This is pretty simple for current workspaces, but I don't know of a way to have new workspaces automatically added to the report. Currently each project is set up as a new workspace, and someone like a department head could…
-
Dashboard Chart to Match Current User Report - Multiple Project Owners
Hello, I have a follow-up to a previous question answered here - https://community.smartsheet.com/discussion/comment/263483 Some of our projects have two owners (two contacts in the requestor cell) so I'd like the charts to reflect the project on each person's dashboard. Currently, I have 1 project in progress and the…
-
How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?
I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return December 2019. Please assist. Thanks
-
notifications on published reports
If I publish a report to someone rather than share it therefore they do not have access to the source sheet, will they get notifications when the source sheet is changed and therefore when the information on the report they can view has been changed?
-
Is it possible to have a report that is editable by people who dont have access to the source sheet?
Within the company I work for we have a source sheet with all our projects in. We need to be able to enable external (sub contractors) people to sign a report which auto fills information into the source sheet. (check boxes) This is so we have an audit history of them accepting projects. However, we not not want them to be…