-
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
-
Only show the most recent associated date in a report for a value that appears more than once
We are using smartsheet to track when facilities wihtin the organization are visited. Essentially, we have a form that employees fill out indicating which facility they went to and when they went there. I am have created a report that will show all facilities within the organization that have not been visited in a…
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
-
Scheduled Monthly report of previous month's activity
to all my formula gurus, Need some help thinking this through. I want to schedule a report that runs on the first of the month and pulls all data from a sheet where a "Closed Date" occured within the previous month. So on Feb 1, the report would pull all activity in the month of January where the "Date Closed" occurred…
-
Dis-aggregate SS start and end dates in exported Excel
Hello, I am trying to see if any of the Excel wizards here can help me with a script or other macro that will disaggregate my SS exported project sheet data that contains start and end date columns (along with the usual duration column) information into individual rows for each day/date that is bounded by the SS start and…
