-
Exporting History Data
I would like to export history data from an existing project, and tabulate the history data in excel. For example, I would like to see how finish dates have changed over time, for hundreds of rows, over the course of a project that has already finished. Is there a functionality to export a cell's (or selection of cells, or…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Lock a Sheet
Hi, Is there any functionality to lock a specific sheet. I dont think there is but this would really help for the situations explained below. There are two scenarios: Scenario 1 We have a master sheet, where all product information is pooled. there are 100 different columns and hundreds of rows. One team is responsible for…
-
Card Format - Report
I have built a report combining all my individual sheets to keep of ongoing tasks in one place. I want to be able to view this in Card View, but that doesn't appear as an option in the Toolbar. Is there something I can do?
-
modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is…
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
changing hyperlink text color in reports?
Some rows in our project sheets are formatted with a dark blue background and white text, however when these rows are pulled into reports it is difficult to read due to the hyperlinks provided in the reports. Is it possible to change this? I would like for the reporting hyperlink to be white for easy readability. I hope…
-
Charts & Graphs
Is this in your enhancement plan for Smartsheet? I don't find this feature like how I can create charts and graphs like in MS Excel. Thanks
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Staff Widget Production Tracking
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed,…