-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…
-
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…
