- 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…
- Prefill Webform with QR Code
Hi all! I've been playing around with webforms and data stored in QR codes for my company. What I've got is when I scan a QR code, it sends me to a Jotform survey that pre-fills fields from the QR code into the form fields. For example, the data stored in my QR code looks like…
- Assembly + Inventory Tracking
I've created a smartsheet to track every unit we sell of one of our particular product lines. The sheet includes the unit's serial number, model number, client name, client PO number, internal 'project number', current location of unit (Ex: "On order", "Johnny's bench", "Software dept.", "Warehouse", "Shipped - En Route",…
- Form Results Page
你能查看所有形式导致sa吗me format as the form? In other words, seeing the form with answers provided (scrolling down through questions) rather than results being displayed across like a spreadsheet?
- Report Builder / Expanded Folders
I'm building a report for a Sight that will have the "Where" data updated often. right now, when I click Where, every single folder is expanded forcing me to close them one at a time and slog through a shared workspace that has folder I do not want to pull from. Is there a way to have all of the folders Closed by default…
- Maximum number of sheets pulled into report?
Theoretical question - is there a maximum number of sheets I can use to pull data into a report? Say we have 300 active projects that all require their own sheets, but I'd like a report to pull a specific set of data from each of those projects (therefore each of those 300 sheets). Will that be an issue? We've yet to…
