Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Fixing a milestone date
Hi, I am building a project that will culmniate in at examination on a specific date. This date is 24th March 2016 and everything else in the sheet builds to this date. How do I stop this mielstone changing date when I change the duration or dates of some of the precedends? Thanks
Project Management/PMO tips
Hi All, I'd be interested to hear how others are setting up smartsheet to support large programmes involving many projects, with multiple organisations, exec sponsors, and project managers. I work in the National health Service (UK) and have a master project list that contains summary information for around 200 projects,…
Export Web Form
Hello. I am trying to use SmartSheet as a relacement for an audit form. There about 90 questions on the audit that would be answered with a selection of A, B, or C. Ideally, those would be checkboxes, but the sheet does not allow duplicate names in the columns. I would like to be able to pull a clear report from the data…
Is there a way to build notifications into a template?
I've figured out how to automoatically share sheets and templates to multiple people with workspaces. Is there a way to build a template so that every time I create a sheet from the template it will also have the same notifications built in as well?
Percent Complete - formulas
I have tried to make my % Complete column a formula which apparently is not allowed. I have 3 columns consisting of 1) Total story points; 2) Remaining story points and 3) % Complete. I want to use the following formula in the % Complete column ((Total Story Points - Remaing Story Points) / Total Story Points). Has anyone…
Adding preceding zeros to a number
I have a column with 4 digits and want to add preceding 5 zeros. I can do single column with '00000 and the number, but I have to do for 4,000 rows and the number are different in every row. Is there a way or formula that can help me add preceding zeros. Thanks
Resource not appearing in Project Resource View
I have a smartsheet that is being used for resource allocation. For some reason one of the resources does not show up in Project Resource View when clicked in the Gantt, any ideas? In the Gantt itself he does show up.
Grouping Rows or Columns
Can you group rows or columns liek you can do in Excel so that you can click on a symbol or such and open up a section of information for easier viewing?
Smartsheet Merge - numerous records to one page?
Hi, How do I merge a number of records to one sheet; i.e. each record does NOT start on a new page. In Word I use the field {NEXT RECORD}. Thanks
Sort not working for Editors?
There is probably a easy explanation or fix for this but I can't figure it out. I have a sheet with about 10 editors that as things move on the sheet it needs to be resorted (sorted by a due date). For some reason I am the only one that can sort the sheet, the Sort option is greyed out on all of thier sheets - I've…
