-
Visualizing comments
Dear smartsheet-community, I have created a sheet where all of our projects are stored. The sheet is filled by a form where you can insert the details. After submitting the form an approval process starts where the teams can approve or decline as well as they can add a comment. My question is about these comments. Is there…
-
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?