-
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.
-
Web Form - Weekly Project Updates
Is there a way to create a WebForm that would allow my Project managers to do Weekly updates on each "sheet" or project? If so, Can that information be placed in a central point? It appears I can only create a webform that update to a row in a sheet? Any thoughts, advice or comments would be appreciated. Sincerely, Scott S.