-
Copy & Paste info from a dashboard?
It doesn't appear to be possible to copy and paste data that is displayed in a dashboard. It sure would be useful for me. Just wondering if anyone has found a way to do this. Thanks.
-
Card View / Contact List
Hi there:) I have a sheet used as a "Maintenance Request" sheet. It is populated by a form. Each person submitting a request provides their name/email into the "Submitted By" column. This allows them to receive an alert once the job is complete. I have frustration coming from the maint dept. when assigning a job/task…
-
Showing Milestones in Sights
I use a Sight as a dashboard, so I created a report to pick up only entire schedule for each project. i.e. I have 5 "bars" in the report, represents 5 projects. And I want to show milestones with each bar. Can I do it? If so, how? Each bar is cell-linking so I can go each sheet (project) if I click and see milestones. But…
-
How can I display a date range based on week/month numbers?
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals. At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc.…
-
Publish a shared google Calendar in a sight
Hi there, I've imported our team google calendar into a smartsheet no problem, and I can see all the entries, however when I try to present this in a sight the calendar grid is displayed without any entries. I've 'published' the source sheet with the calendar import, and both the source sheet and sight are shared with all…
-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Desperate for help-dashboarding
Ok about to rip my hair out on this. I am needing to create a portfolio view dashboard and when dashboards were widget driven I COULD DO THIS EASILY. I just want numbers for the following on the dashboard- # of Executing projects by PM (Name) # of projects >50% # of projects <50% # in Yellow, Red, Green # Paused (yes this…
-
Dramatic loss in picture quality when posting to dashboard
I am having a dramatic loss in picture quality when posting to the dashboard. Is anyone getting this as well? I even added an outline to the words and you can hardly tell in the dashboard.
-
Reference another sheet using sheet name
I'm almost certain that there is no solution to this situation, however, here goes. I have a workspace with approximately 35 project sheets. Each project has approximately 50 tasks and each has a schedule status in a "Schedule" column. I want to be able to count these tasks based on their stats and report on the entire…
-
Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…
