-
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…
-
Share reports without sharing entire underlying sheet
Hello, I would like to understand the best process to, once a month, update a sheet with data from 2 partners. then I would like to share just that partners data with them for viewing and possilby updating. is the best way a report on top of the sheet with a fitler? i tired this and it seemed that they could click through…
-
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
