-
Tracking specific changes in a project plan to second sheet for reporting
We have many project plans that are in our portfolio and I want to be able to report from each project plan when a CHANGE is made for only three fields of the many that are on the sheet. The fields are in the sheet summary and then in a formula in the first row of the project plan for reporting purposes. My goal is that if…
-
Update Requests Icon
Hello on a previous version of a sheet we were using, we were able to view pending requests by row. On our newest sheet, the previous updates disappear once viewed. Is it possible to keep the icon visible?
-
"Simple Project Portfolio" template - video demo?
Is there a video demo how to use the "Simple Project Portfolio" template? It looks intriguing and could be what I'm looking for managing multiple projects. But it's confusing and there's no instructions. https://www.smartsheet.com/template-gallery/simple-project-portfolio
-
Average in Reports to exclude current week
Hi, We have some KPIs that are measured on a weekly basis. I have a sheet that calculates weekly totals. When I pull a report to see weekly averages on a 4 week or 3month basis, Monday morning the totals are skewed because the totals for the current week hasn't accumulated yet. Is there something I can do in the report to…
-
Why are columns not printing in the width that I've set them on the report?
We have a lot of people complaining about the size of the reports when they print. We would like the content on one page, and when we shrink the column width in the report it still stretches out when printed making the font very small. Is there a way to maximize the page similar to excel when you pick the "fit columns on…
-
How do I copy and paste multiple cells from an excel spreadsheet into a SmartSheet?
I need to copy a group of cells from an excel spreadsheet and paste that into a column of SmartSheet, how do i do that?
-
Sum months for Dashboard
Hi, I am creating a dashboard for month wise data, what i am struggling with is that if i have rows for multiple months then it is displaying as seperate bars I wanted to merge that amount into one month. Attaching a screenshot below, you can see there are two septembers I wanted to merge or sum that into one, Can any one…
-
When I upgraded from a trial account to a paid 'Pro' account I lost access to certain functions.
Hello, I recently upgraded my account from a trial to a Pro account and I am unable to do certain things. I am able to click 'Add column right' or 'Add column left' but not actually able to add a column. Additionally, certain functions are greyed out, such as 'delete column' and 'rename column'. I checked and I am still…
-
Customized Reference in Comment function
Hi there, I am new to SmartSheets and have set up my team to use for project managing and bid/estimate queuing. It has been very successful thus far. I did get a question from a teammate asking if there was a way that when a message/comment has been added to a Row, instead of simply showing the row number, the project name…
-
Update a sheet based on changes in another sheet
Hi all, I have successfully created a system for recording and tracking engineers call outs for our small family business. We use workflow to move the jobs through the various sheets (stages) of the process. All good. Now though, a new request has come to me and I'm damned if I can work out how to do it. Any thought very…
