-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
-
Multi Select Column in Reports
I am using the new Multi Select Drop Down Column type, I have 2 options for check off in it. When I want to filter it in a report the check off items don't show up. I can find the column in the "What?" Section, I add it, but it will only let me filter it by "blank" not by the 2 options I have put it as check off fields in…
-
Dynamic reporting across multiple sheets
My organization recently moved from Google sheets to Smartsheet. We were tracking the number of jobs completed by each team member in the last week. We had multiple groups of jobs that would be uploaded as a new tab on the sheet. The reporting we had set up was able to search the new tabs for data to include in the report.…
-
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
