-
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…
-
Question on SumIFS
We're hosting a "Bike to the Moon" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field that sums across all their trips (rows.) I'm using this formula at the moment but I'd rather not…
-
#INVALID DATA TYPE Error
I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will often be blanks. My formula is below: Adding an IFERROR avoids the error message, but I…
-
How do I pull risks and issues from multiple projects into another sheet?
I am trying to create a programme view over a number of projects. I want to be able to gather all the risks and issues from the various project raid logs into another sheet so, it can be displayed on a dashboard. How is the best way to do this?
