-
How to analyse/illustrate slippage of tasks in Smartsheet
Hi, I would like to get my sheets to highlight tasks which are overdue for completion in Smartsheet, and any subsequent tasks which may slip as a result. I imagine I will need to do a formula for this would be grateful for any advice on how to do this. Thanks
-
Tracking overall attendance to event
Building 2 different pages, one for general registration throughout the year, another to Track which companies have been to which events. The Registration is coming easy but how do I get it to fill in the Tracking sheet/report? So the Registration will track all the attendees for an event, of which there could be 1-10…
-
Reports - Hide the original sheets
We have master sheets that contain information on all products across 6 factories. We want to create a report for each factory that they then update relevant information for their products. This then allows all data to be viewed in the master sheet. The problem is that the report will show only the products that they have…
-
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…
-
Search Function for Report Rows
Is there a way to allow the search function to search reports? I have used the search function from a report and search returns only rows from the controlling sheet. The report is used to give a user access to just the information they need to see/edit. The user getting sent to the originating sheet only makes it difficult…
-
Formula to get data from current week only by day of the week.
I have a worksheet with case information and who these cases are assigned to. I am trying to add columns that will total the cases from each day of the current week. ex. columns with a total count for mondays cases, tuesdays cases etc. thru friday. This worksheet has data for the whole month and all I need is the current…
-
Generate Report per Row
Is there a way to generate a report per row? I have one project for each row with numerous columns. I would like to create a one page report that list the columns in a vertical format with the data from its corresponding row. Does that make sense?
-
Sights font size
Hi, Is there any way to choose larger font size than 36? I have a large 50" screen which shows 5 tiles with 4 rows of data, that is updated every minute (since today's enhancement of auto-update). It works perfectly! Love it! BUT: The biggest font is 36, so numbers are visible from couple of meters, but if I step further…
-
Report - Imported sheets are shown but new Project Sheet does not
Hello, The majority of the time we import an MS Project schedule and have had no problems with pulling those into a report. However, if we create a new blank Project Sheet and enter the tasks through the web interface, those sheets do no get pulled into the report. The columns for the Start & End dates are different…
-
Monthly Management of Projects
Hello All, I am now responsible for reporting on the progress of multiple projects in our organisation and what is going on. I have created Sights for each that roll up into an overall position to save time and effort. However, I would like to create a task list for myself to make sure that i have covered all bases on…