-
How to organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to…
-
Displaying a Report Full Size on Company Intranet Site
I have created a summary project report that is displayed on our company's intranet site using the embed code. It does not fill the page and the viewport becomes very tiny on smaller screens. Is there any way to display the report in full size?
-
Feature Request: Timesheets / Time Columns / Time Trending
What we want, is to be able to generate a daily or weekly report of how much time each person worked, and on which tasks. We need to be able to not only see the efficiency of the tasks, but also of the people. And if we can select a specific period of time, this would also be useful. I have a project where each row has a…
-
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
-
Rolling Week View in a Report
We have a smartsheet with multiple rows of activities and column headers: "PSA Start" and "PSA End" dates. We want to build 3 reports that shows: (1) PSA End dates due in 0-2 weeks (2) PSA End dates due in 2-4 weeks and (3) due in 4-8+ weeks. Can this be done directly from the report or will I have to create calculations…
-
What's the best way to show Baseline Schedule when it's not available on the Gantt?
We are using the Baseline "workaround" by creating the Actual Start, Actual Finish and variance column formulas. What method has worked for you to compare the baseline to the actual since it's not supported in Gannt view? *already upvoted this feature!
-
Reports - Using formulas against reported data to pull into SIGHTS?
Hello, Was unable to find this topic and for some reason thought report 'formulas' was on the 2017 roadmap for March but on couldn't find the community or annoucement so here I am. I have a report pulling from several project plans. Within the report I'd like to summarize the reported data using formulas. example:…
-
Feature Request: Update Request confirmation has same title as the Update Request
When I send an UR to someone for a row, the title of the UR shows the name of that row plus whatever I add. However, when they complete the UR, the confirmation only shows the title of the sheet. Also, if I send the same people UR across many days, I have no way of knowing what they completed for these days unless I open…
-
Could somebody please help with formulas and reports
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date. I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users If anyone can…
-
Program and Project Sight Templates
Hi there, I really like the look of the Program and Project sights in the Sight Gallery. Can someone send me the Sight templates and the underlying smartsheets and reports needed to make it work? I'm hoping it pulls from the Basic Project and Basic Agile templates. Thank you! - Janet
