-
Reports pulling data from a sheet
I there somewhere you can look to see who has a report pulling data from a sheet? I recently made a column type change in a sheet and this impacts a report if the column is selected. I know the Activity report within a sheet shows some items but not if the sheet is being used in a Report. Thanks, Peggy
-
Stacked Area Chart?
Hello, I would like to report the issues on my projects using a stacked area chart as per attached screenshot. Is there any way I can do this in Smartsheet? I am mainly talking about Dashboard functionality. Thank you!
-
COUNTIFS with more than 2 criterion
Hi, I am trying to do a count for a field with 3 criteria. I want to do COUNTIFS( A = "x", B = "y", and C = "Z"). Is there a way to achieve this as COUNTIFS only allows you to do this with 2 criterion?
-
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…
