-
Page LInking
Hi There I'm new to Smartsheet, and trying to see how best to use it for our company, within the event industry. I'm working on a large event, and have multiple venues and contractors, which i'm trying to link. I have venues A, B, C, D etc and contractors 1, 2, 3... who work across all the venues. At the moment, if I have…
-
30 60 90 Initiative sheet
Does anyone have a good/great template/report or dashboard already created that you are willing to share. I am new to smartsheet and have ideas....but limited time to put something together. It is for and acquisition project. Currently have a WBS by functional area...need to quickly strip strip key tasks & milestones out…
-
Multiple View Types
Hello Community :) I am wanting to share a Smartsheet among several different companies with different levels of information. That is to say, some of the columns from the originating company generating the Smartsheet are not to be seen by users from the other two companies, and at the same time there are columns from the…
-
Help with creating a dashboard
I'm new to smartsheets. I've set up a work tracking sheet with a number of status conditions. I'd like to create a view for folks to use - maybe a dashboard? Let them check the status of their requests, show a pie chart representing the total number of requests in each status, average time to completion, etc. Any ideas…
-
Report showing resources and assigned projects
I'm looking for help developing a report. I've got multiple projects and multiple resources working on those projects, and I'd like a simple grid - resources in a column, project names across the top, and an x indicating which project each resource is working on (or something like that). This view will give a snapshot of…
-
Link clients, jobs and opportunities
Hi guys. I use SmartSheet to track clients, jobs and opportunities. I have a sheet for each. For the most part, it works well. But the one area it's letting me down is linking relevant records. I'd like to be able to go to the client card and see all their jobs and opportunities. And I'd like to be able to go to a job or…
-
Creating a Temple for Router Configrations
I have an existing sheet with a lot of information in it. I would like to create a template to populate based of the information in my existing sheet. Then I would like to be able to print or export the information to create a router or switch configuration template. Sounds easy enough but have never done this and would to…
-
Opening a template by selecting a check box or status field
Hello all, I am very new to Smartsheet so please excuse the question. I know how to do the following in excel but haven't found a way to do it in Smartsheet. I have a list of courses that belong to certain programs. I would like the program chairs to select the courses they would like for my team to work on by selecting a…
-
Best way to manage an iterative process in Smartsheet
We are planning to implement a book publishing project in Smartsheet. At one point in this project, the pages of the book go back and forth between the writer, editor and compositor till it gets finally approved with no further changes being required. The number of times this cycle repeats itself is unknown, however there…
-
Touch Sheet to update formulas with Vlookup
can a Vlookup (or other cross sheet reference) be used to touch a sheet to update today() formulas in unopened sheets? if we can exploit this cross sheet functionality I might be able to create a master sheet that I can open and refresh all of my sheets daily without having to open each one of them. This would allow me to…
