-
Embed certain columns on another page?
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira tool to document and report statuses, would like to embed this gannt view but exclude the column with notes so it's a cleaner…
-
Help needed with formulas - paid work opportunity!
Hi everyone, My colleague and I are new to SmartSheet and we are having some issues with a few formulas and we can't quite work out what has happened. We are offering paid work at an hourly rate for someone to join our team to help troubleshoot and fix our SmartSheets issues. If you're interested, please let me know!…
-
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!