-
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…
-
I need to pull data from sheet on a monthly basis.
What is the best approach? I have set up sheet summaries with the data I need pulled into categories and I'm using these summaries in a report, but I need to separate this data based on dates. I am stumped as to how to get what I need.
