-
Report refreshes inaccurately
We have a report linked to one sheet at a time, used to view relevant information without the distraction of all the details. We edit in the report and save. Sometimes we will edit in the sheet and save there. We run into two issues: 1) Edits in the sheet don't always pull into the report. 2) Some text/number fields can't…
-
Report not sorting on given column
I have a report that is not sorting on the column I specified. It was working yesterday, but today it is not working. It is to-do list report that is sorted by Forced Rank. I can sort by other columns (e.g., Due Date), but for some reason the Forced Rank sorting is not working anymore. Forced Rank is a Text/Number. Forced…
-
Populating existing sheet rows through a form
I'm looking to collect weekly sales reports from a number of sales teams spread across different countries. Ideally I want the data from each weeks sales report to drop into a row (with the week number and/or week end date) in my master sheet. Some of the data in the master sheet will be pre-populated (overal…
-
Summarizing Data using CountIF
I have created a Status Tracking sheet with multiple records. Each record represents a summarized view into a detailed task template. Each record also has a Status field, which we use to describe the phase of the project that we are in (there are four phases). I have used Countif to count the number of records in a given…
-
New Published Reports
Hi, I would be interested in what people think of the new way of publishing reports. I have had a customer come back to me with negative feedback. It looks and feels like a smartsheet not an output to place in a Webpage as part of a dashboard of Reports, charts and other information. The older style looked like an output…
-
Smartsheet Reports going directly into a sheet as an attachment
Hi, I wondered if anyone knew how to upload a report directly into a new sheet? At the moment I email the report that I have run and add that report as an attachment to another one of my sheets, is there a way this can be done missing out the email link? I'd love to run the report as an excel document and attach it to my…
-
HOW CAN I VIEW ONLY LINES WITH RECENT CHANGES
I WOULD LIKE TO 'FILTER' TO VIEW ONLY LINES WITH RECENT CHANGES .NOW I NEED TO USE YELLOW HIGHLIGHT TOOL AND SCROLL IN THE LARGE DOCUMENT WHICH TAKES TIME TO DO.IS THERE A QUICK WAY JUST TO SEE THE LINES THAT CAHNGESD AND THEIR PARENT WITHOUT USING THE REPORTS?
-
Convert Project Sheet with Start/End Dates to Weekly Summary Showing Items Starting/Ending/In Progre
Hi - is there a way to convert a project sheet with items that have Start/End dates listed, into a week by week summary report that shows the status of each of those items in a particular week? In any week, I'd like to see which items are Starting (based on Start Date), Ending (based on End Date), and In Progress (assuming…
-
Pull Down Menu Options from Common Source/Sheet
All, I am using Smartsheets to track time, and have run into an issue that I have to believe there is a workaround for. We need our associates to track their time with specific job and client IDs. This can be done by making the time tracking entries show as a pull down menu of codes. But, when we get new jobs or clients,…
-
Not receiving any updates or reports today
Not receiving any updates or reports today. Is there anything wrong? I have automatically scheduled reports to be delivered daily at 10am via email. I have received nothing today. It is almost noon. I also get notifications from smartsheets when they are updated. I have received nothing today which is also unusual.