-
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…
-
Need to Display image attached to sheet in Dashboard - is this possible?
I need to create a dashboard that shows a continual stream of upcoming new products. I can create a report easily enough that will show this info but I need to include an image of each new item along with the data. Is there any way to do this? Alternatively - is there a more "visually appealing" Dashboard design or…
-
Remove Gant view from Dashboard report
Hello, I added a date column to my report to show the actual date in the Dashboard but for whatever reason, the Dashboard wants to display the Gant view only for the date column. Can I turn the Gant view off so it only shows the actual date like it displays in the report??
-
Tabs No Longer Showing
Sometime last week I noticed my view in Smartsheet (using Chrome) no longer has the tabs at the top of all of the current open sheets. How can I get this view back? It was much more efficient than the pinning option we have now. Also, the recently reviewed Smartsheets would be great if it actually filled up that column but…
