I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for…
I would like to create a single report pulling data from multiple sheets based on primary column, start end date, Assigned to and status. How could I achieve that? Currently even if I add multiple sheet to report criteria it pulls data only form 1 sheet.
I have a risks&Issues register sheet and would like to create a table in a new sheet which categorizes based on Streams and risk/issue rating. How do I do it. Attached is the sample. I would like separate tables for risks & issues
This is day two of an issue that we are experiencing where our live data link to Excel is linking every field except date fields. Hoping there is a resolution in process for this issue. How do we submit a ticket for performance issues? Thanks, Ken
Hi, I just updated a couple of my sheets and changed the duration time to "0" to reflect a milestone. When I run my milestone report these changes are not updated. Is there a delay for some reason. I thought that updates once saved would be immediately reflected. -Laura
Hi - I'm relatively new, have watched videos and searched articles but I'm stuck. I have 50+ training products and a ton of potential job roles and location combinations. I'm trying to use SmartSheet as a "database" where I can select from a set of criteria and have that spit out a custom set of recommended training…
I have a column in my sheet that contains a list of names of people that are attached to that record/row. I would like to add another column that displays the number of words in that column - just a count of people attached. So if the first column says "Jane, Jack, Jay", I'd like the second column to say "3". I can't…
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
Hi, Is there a way to pull a report of what sheets within Smartsheets are being regularly shared through automatic emails as an attachment? Thanks, Dan