-
Sorting recommendations when you have summary rows on the top on your sheet
I am experiencing issues when sorting a sheet and have summary rows at the top. For example, I created summary rows on rows 1 through 10 with formulas and totals, and when sorting, my summary rows get lost in the sorting process. Do you have a workaround to prevent this from happening? Ideally, I would like my summary rows…
-
Resource exports
Hi I'm wanting to use SS more in how we do resource planning. One thing which is quite painful is the output from the export on the resource view. What would be easier as a complimentary tab on the excel export is a more "Pivot table usable" output, for the same range so something like Date Project Resource Allocation this…
-
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
-
How to calculate schedule % updates in Smartsheet
Hi, I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration. i added a column with percentage updates as per schedule however, these percentages do not roll up to the…
-
Report Criteria Bug?
I have a report that selects rows from several sheets based on a date field being 'today or in the past' and a status (drop list field) being set to OPEN. For one of the sheets it is including a row with the date in the future. I've tried saving, re-entering and saving in both the report and the original sheet but it still…
-
Adding expanded comments to sights or reports
If people are using the Comments column to provide status updates on line items, can those be expanded somehow in sights or reports? Or do I just need to add a column for Status Notes in each project sheet that I have?
-
I want to utilise an IF THEN function in Smart sheet
My example is to select a cost rate based on the employee title. If [cell1]="welder" then [cell2]=80, if [cell1]="crane operator"then [cell2]=100, etc, etc.
-
Reports: last update vs last run
Hello Would it be possible to see in a list of reports (workspace) not only the 'last update' = report builder update, but also when the report was run the last time? Suppose those are two different things? thanks jan
-
Business Resumption Plan
Does anyone currently us Smartsheet in their Business Resumption planning?
-
Project Roadmap on Calender view of report
Hello, I have a master project list sheet setup. I am attempting to create a project roadmap so we can look at the big picture. I was able to create a report that shows every Active, On Hold and Not start project. Here are my two issues: 1. The calendar view will only view out to 1 month, is that the limit or is it a…