-
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…
-
Feature Request: Timeline within Smartsheet
One feature that MS Project had that I've had a hard time working around is a timeline feature that is part of the application. I understand that SS integrates with Office Timeline, but I have to pay for this, manually manipulate this, and I have to recreate a timeline each time deliverables change on my plans. We have a…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Feature Request - History view
Ok, so it's nice to be able to see how things are trending, but given that things keep changing it means you need to have to keep old reports or backups around that you can plug into excel. Wait though, we have the history of each cell available within two clicks. And we have the highlight feature which shows which cells…
