-
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…
-
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…
-
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…
-
printing gantts, printing stuck on quarters
When I attempt to print a gantt chart, the printed version always shows the dates in quarters, even when I am viewing weeks or months. How do I get the printed version to match what I am viewing?
-
% complete based on count of child checkboxes.
I'm hoping someone can help me. I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular…
-
Send update requests to assigned user?
Is it possible to send an update request to the user assigned to the row? For example, I have five tasks listed on my sheet, each assigned to a different user. I would like to select all five rows and hit 'Send Update Request' and use the 'Assigned to' column to determine who it should go to. Having to re-type the…
-
Production/task management with sales order taking
We are a small custom sign manufacturing company. Our clients can order any number of products at a time ranging from small items to custom furniture. All have a similar start to finish process with some customization along the way. We would like sales reps to be able to enter orders directly into a page with details on…
-
Using COUNTIFS across multiple columns for one criteria
Hello All, I hope you are all doing well. I'm trying to use the Countifs formula by referencing our Portfolio Project sheet. I'm using five columns. One column is the project status which I am limiting to those projects with a status of "In Progress" (Range 1). The other four columns are columns that I titled, Project…
-
Smartsheet overrides workflow approval
I have a multi-step workflow approval set up. Form entry submission sends an initial request to the manager. When manager approves, next approval goes to center administrator. Once that's submitted, then it goes to one more and then the director. Problem is that smartsheet is overriding the "Approved" status from…