-
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.
-
ideas for department wide status report
The director of our department wants to use Smartsheet to consolidate status reports across multiple managers showing the latest status update for a Task(Row). We could do this in one sheet, but we want to be able to have historic (older) updates for the Task stay on the sheet. My idea is for each mnager to have his/her…
-
Rollup report missing rows
Can't figure this one out. Hoping someone can help. I have 6 sheets for various projects we are working on. Each sheet has at least one level of heirarchy and some have up to 3 (parent/child/grandchild?). I have used cell linking to create an "amalgamation" sheet that lists all of the projects with their related…
