-
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…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
-
Creating separate charts on a dashboard using the same report
Hello, Our team created a large sheet that collects data from Smartsheet forms that vendors complete. We then score those answers and send them to a Vendor Vetting report that only shows the scores and some basic additional info (fake data below). Is there a way I can create charts in a dashboard that only shows data based…
