-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Is it possible to apply Conditional Formatting with a formula?
In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below. I need to compare column values to the value at the top cell. I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.…
-
Deleted users in "assigned to" resource management sheets
What happens to sheets that are resource management enabled and have "assigned to" columns with users that have been (subsequently) deleted from our account? Is there a best practice on how to maintain assigned to data from deleted users for archival/reference purposes? Will resource views still function? Reports?
-
Enhancement Request: Show indent levels of project tasks in reports
I would really love to see the indent levels of tasks in report based on a project plan. Today all tasks are shown left-aligned. With a rising count of tasks, subtasks and subtasks of a subtasks (and so on) it becomes confusing and unreadable. People not as deep into the plan as the project manager get totally lost very…
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
-
Linking Reports in different sheets
hi guys background: I work for an investment management company. Internally we have about 6 different reports that are interlinked in this manner Report 1: the starting point is an events or presentation calender Report 2: the actual presentation report, where feedback is gathered from presentations that come from the…
-
Delta/Slippage Formula
I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules. I have individual columns for Original Finish (Date), Current Projected Finish (Date), and Change Order (CO) Days that are populating dates and numbers with cell linking from the…
-
Dashboard - Report Column Widths look ridiculous
I have a report that feeds into a dashboard with 8 columns: * At Risk (flag column) * Health * Task Name * Assigned to * Status * Progress Bar * Start Date * End Date Why does it stretch that last column (end date) so wide? It looks ridiculous. The At Risk flag columns is a very appropriate size for the content. So it the…
-
Print Scaling Inconsistent
I have 2 separate reports. The first report is 44 rows in length. From smartsheets, when I print the report and use the Fit to Width function, the report is 1 page wide by 1 page long. This report has 16 detail columns. The second report is 37 rows in length. When I print and use the Fit to Width function, the report is 1…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…