-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Report Builder not showing all column options
I've been trying to pull in some additional columns into a report from the same sheet that the other columns are pulling from. When I click on 'What?' in the Report Builder, it does not show all of the columns as options. They are columns with dates and are no different than other date columns that show up as options. I…
-
Report Notifications
Is there a way to set up notifications within a report? We use reports to keep project managers up to date on new projects and a notification based upon the addition of new information would be helpful.
-
Exporting only parts of SmartSheet to Excel
I have 5 project phases 1 thru 5. Each phase has the same deliverables. I have a Smartsheet with the list of deliverables for all phases numbered e.g. 1.01 for phase 1, 2.01 for phase 2..... 5.01 for phase 5. See attached example. I want to export to Excel only all the deliverable for a specific phase e.g. 2.01, 2.02,…
-
Can't see dropdown list in report but i can see in source sheet
Can't see dropdown list in report but i can see in source sheet
-
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?