-
Building sheets that talk to each other
Hello, I have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work. I basically want one sheet that our shipping team updates to automatically update another sheet my purchasing team uses. The columns have dates and check boxes so when…
-
Bank Statement Checklist and weekly notification of missing statements
Good morning, I am trying to build/find a Bank Statement Checklist that will notifiy me of all missing bank statements. For example, as of today, we should theoretically all bank statements from October 2018 and prior. I would like a monthly email sent out notifying me or somebody of all missing bank statements. I am…
-
Presetting Project Start and End date - Missing in Smartsheet
In Microsoft Project, you can set a project schedule's start and end date and that sets the date range for a project schedule. I can't see that feature in smartsheet. This would be nice since a lot of us use templates in our PMOs that we'd like the ability to do this everytime we start up a schedule so the dates pre-fill…
-
Is there a way to auto-fill across the header?
Hi there, Is there a way to auto-fill across the header? For example, if I put the very first date and then add a formula to add 7 days across until the end of the project? Or do you have to manually enter each header? I am trying to find an easier way to update template headers. Thanks, Jill
-
Hyperlinking Templates
Is there any way to hyperlink a template from a Smartsheet?
-
Rollup percentage in project schedule template is not calculating correctly
I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to…
-
Feature request: copy a "column" (column name, formatting, configuration, etc) from one sheet to mul
Feature request: If I create a column with a specific name, configuration, formatting, etc - it would be nice to be able to copy that column over to another sheet - or better yet, to multiple sheets. Or - an ability to "link" multiple sheets together, based on a specific template, and if you make a change to the "template…
-
Credentialing Tracking Template
Hello, I am looking to set up a credentialing tracking template. I would like to track the credentialing process including but not limited to documents submitted/pending, approvals, etc. I'm curious, does anyone out there have any examples of such templates? Any ideas are much appreciated. Thank you!
-
Meeting agendas for Local government
Hello, I am wondering if anyone has used the Meeting Management template to create a Council meeting agenda? If so would you mind sharing how that works for you. Thanks, Jaquisha
-
Stacked Charts
Hello 1. I am new to the smartsheet community and would like to know if it is possible to plot dates using the charts widget in the dashboard. I intend on plotting a stacked bar chart with dates and duration. (As show in Figure 1) 2. While using the clustered bar charts option, is it possible to a merge the bars, something…