-
Expanding Reports from the Dashboard
I have a dashboard widget that connects to a report that summarizes all of the unique projects in my department. The report only shows the project name and the gantt chart timeline. I want the executive manager to see this report but to also click on it if he wants more detail. However, when he clicks on the report it…
-
IF AND Function For Reporting
Hi guys, I am trying setting up a new report for my team which will allow them to bring through project activities based on the following criteria: * The week the activity happened in is before today's current week. * The RYG status is red OR green OR yellow I am using a column set up as a checkbox and trying to put an IF(…
-
(2) Reports in a Dashboard Showing the same answer?
I have 2 reports sitting next to each other in a dashboard. One shows a summary of what was due yesterday. One shows a summary of what is due in the next 5 days. "Due Yesterday" report is set to show anything with an End Date in the last 1 day(s) "Due in the next 5 days" report is set to show anything with an End Date in…
-
Sheet Summary Report - Want to edit fields within report
I created a Sheet Summary Report, and have found that the fields within the report are not editable, unlike a Row Report. In a Row Report, I can click into the cell directly within the report and update it. On my Sheet Summary Report, the cells in report are locked down and uneditable. Am I missing something in order to be…
-
Sharing Report to non-licensed users
HI, I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users. Before we signed up to the paid account this was an option. Thanks, David
-
Flag By Date Column 6 Weeks or Greater in the Past
Hi, We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete" What is the formula that I can use in a flag column to say - Flag any with an Order date 6 WEEKS OR GREATER, and Status NOT EQUAL to Complete? Thank you so much in advance! Jared
-
Ghost data from unused SCC template remains
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an…
-
Automatic forms generated from report display all main sheet fields on browser
I think I've found a bug: Automatic forms generated from reports in the browser (right click in the line mover on far left > edit) display all main sheet fields on it. It doesn’t matter what columns I have chosen to display in the report creator, but in the smartsheet android app the automatic generated form of a report…
-
Report viewable to others
Is there a way to make a report I have automatically available for others to view it? Daily I click refresh on a report so the executives can have the most up to date info. My boss clicked on the report and it was empty. The report was shared with her as an editor. Can others not view the report anytime they want?
-
Unable to Modify End Date in Report
I have a report in which I want the stakeholders to be able to update the start and end dates that are used for resource scheduling on the report and not the Smartsheet with all the raw data. We can modify the start date but not the end date. Is there something preventing this from happening? I cannot change it either as…