-
Duration as a report filter
I'm trying to set up a report of my to-dos that have a duration of 5m or less but am having trouble setting up a duration filter based on anything other than whole days. I know I could probably create a custom column in every sheet with a checkbox to say the task takes 5 min. or less or a formula converting the duration…
-
Connect reporting tools to a smartsheet REPORT
Smartsheet reports is hardly what i would call "reports". It just combines data from multiple sheets into a single sheet based on creiteria. Great. But that is just a start. That is just raw data...there is very little insights you can draw from that and it's precisely the stuff management does NOT want to see (raw data).…
-
Hierarchy in Reports
Is there any intention of offering a hierarchy in the Report view? This would be especially useful where the report includes parents of the items found for the report. Thanks in advance, Neil
-
Tagging Smartsheet rows
I am planning to add a Dropdown List column to each of my Smartsheets with the column name Tags. Before doing so, I thought I would check with the Smartsheet Community to see if people have done anything like this. I will be using the tags in reports serving as to-do lists, starting first with the Getting Things Done (GTD)…
-
Portfolio Report based on Projects & Gantt incl. milestones (1 line)
Hi, I made a report based on our active projects, showing the gantt chart.. (We have just started using Smartsheet, so not all of our projects have the right data) What I would like to see in the Gantt chart are the milestones. Is that possible with some nice adjustements (or clever tricks ?). Teach me, I haven't found it…
-
Gantt report: Knowing Real progress percentage vs. Expected percentage
Hi. As is somewhat difficult to explain for me in english the requirement that I have, I'll use the google translator. I need to know if it´s possible to have by a Gantt report: -To be able to see on any given day (usually the day that I require to present a progress report works) that have real progress percentage vs.…
-
Creating a Report is slow
Or is it just me? Or my Windows PC? If there is something I can do on my end to speed this up, I'd like to know. I have Chrome open (Firefox is MUCH worse) and can view the Home Tab. Go! I click on Create New > Report and watch the loading screen - 12-15 seconds (Firefox 17-20) the Report is created but is not open 1. Time…
-
Report showing different color than the row in the sheet
Hi - I have a report that I run that shows me all the line items from various sheets that are assigned to me. On the report is a column for "Sheet Name". When I run the report, all of the rows from one of my sheets looks the same - the value for Sheet Name shows with a white background and a blue link that I can click on…
-
Reporting based on % of work
I need to have an initial graph of the amount of planned work schedulled for each week of the project. The "X" axis will have each week and the "Y" axis the % of work to have done. I am sharing a graph as an example. The blue line will be the planned baseline project. The red line the real work on a weekly basis. Any ideas…
-
How can I delete recurring e-mails?
I have two recurring e-mails that I need to delete due to a personelle change. How do I do that? They are from a report and when I go to e Send or Share Sheet, Send as attachment they show up on the right but it won't alow me to select Edit Recurrence or Delete. Thanks, Jamie