-
Best method to update a project sheet
Hello everyone! I'm a project coordinator at a company specialized in manufacturing and installing irrigation systems, we have over 50 projects going on at the same time. We're trying Smartsheet to check whether it suits our needs, we're looking for a way to let a user supervising the project to update the progress…
-
Chart Horizontal Axis
My data values range from 0-50 however when adding a chart the horizontal axis reads like this... 0, .50, 1, 1.50, 2, 2.50, etc. How can I change it so the axis is whole numbers solely. My data is whole numbers and therefore I would think it should reflect same.
-
Pull data from another sheet depending on two values
I need to put the excess data onto another sheet depending on the month and supplier. This is the sheet Im pulling the data from So if someone places a request i can track their quota for the month and tell them if they are going to exceed it or not. The other sheet is where they place the request and these are the columns…
-
Live Dashboard Presentation
Hi all, I am needing to present a few of my dashboards, in real-time, on a 24 hour cycle. I will be presenting about four individual dashboards but I am running into a bit of a snag. I tried using Revolver Tabs in Chrome, but when the tabs rotate it auto-refreshes the new screen which causes the full screen mode to…
-
Google Sheets Merge Multiple Pages
Hi There, When I am linking over my data to google sheets with the merge, it creates a separate page for each row. This would normally make sense and work fine, but for the setup we currently have in our sheet, one item takes up several rows, thus spreading out the one item across multiple sheets. Is there a solution to…
-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
can smartsheet support "comments" and “cell merge”？
Hello, I am wondering whether smartsheet can support "comments" and “cell merge”？ -Cell comments: Write a comments for the value in the cell, like excel? - Cell merge: merge the adjacent cells as one cell - Two level columns headers: Ex: Level 1: Jan Level 2: Qty, Amount, Price Now I can only write header as: Jan qty, Jan…
-
Parent level approval requests?
Is there a way to set up approval requests at the parent level? Parent row includes project description, Owner, PMO, etc, etc. Child rows break out task types into groups Grandchildren row list owners of each task under the task type group. Example: Description Owner PMO * Project XXX Jon Doe Pam PMO (Parent row) *…
-
Charts with no data
I have a dashboard that I update weekly to show any applications that were processed through our office. Sometimes, there are weeks where we don't have any applications processed, so I don't have any data for the week. Is there a way to customized the error message in the chart? I've included a screenshot. I just want it…
-
Data accuracy
I am working on a way to verify if data in all my sheets (about 10) is accurate, however, the trouble I am running into is the data is frequently updated. Is there a way to run a report that is like activity log within each sheet? Thanks, Amy
