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…
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 t…
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 …
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 maintai…
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 …
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 sa…
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 presentat…
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), Cur…
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 col…
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…