-
Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
Currently in a Project Sheet there is no way to automatically change a Date in the Finish column once the % Complete column changes to 100%. I am trying to have the schedule auto update the predecessors start and end date based on the date the ancestor task actually was completed. There is currently no way to automatically…
-
(Grid View) Cell and Column Data Validation Rules
What if we could add required value and data validation rules to any text/number columns. This could be to enforce either blank or a value matching the formatting, but would help with data validation across the board. My use case, in particular, is that I pull in data from Smartsheet to a data model and data visualization…
-
Calendar
I have a suggestion regarding the PDF export feature for printing calendars. When trying to print a single month from a multi-month sheet, the system currently defaults to a two-page layout. For example, if I want to print the calendar for August (8/1-8/31) on one page, the system defaults to print from July 26 to August…
-
Resource Manager - Date or List Pickers - Enable ability to type date
Currently in RM, any date or List picker function you have to physically pick the date or item from list - there is no ability to manually enter the date or to type the list item in the input box and either select if from the already saved record or create a new one. e.g. I have recently had to go back through and enter…
-
Give Pro plans unlimited sheets for Reports
Right now a Pro plan which is used by smaller businesses trying to grow, can include one sheet per report. It's a 1:1 ration between reports and sheets. So you can have "unlimited sheets" on Pro, but only one report per sheet. This is kind of a strange limitation because there's really no reason to have a report for a…
-
Remove Yourself from shared WorkApp
It would be nice to be able to remove yourself from a WorkApp that you are shared to in a similar manner that you are able to remove yourself from a shared sheet.
-
Automation to move row or Drag and drop under collapsed parent row
I want to drag and drop under a collapsed parent row. Parent rows with many children must be expanded then scrolled to bottom of children to drop new child in place. An automation to move rows once a cell value is changed to the parent row would be better than dragging and dropping.
-
Project Timeline Linking in the PMO Template Set
Hi, I am looking for a way to link my timeline to the different sheets within a project. I like to change the name of the file and while it works with the Project Intake Sheet and Metadata Sheet it does not for the other sheets such as Task Roll Up, Overdue etc.
-
Request for Formula for Calculating Elapsed Time
In Smartsheet, we often need to determine how much time has passed since a project was opened to prioritize its completion based on the elapsed time. To do this, we need to calculate the difference between the current time and the project's creation time. It would be helpful to have a formula similar to NOW() or CURRENT()…
-
Form timer
Suggestion to have the option to limit the time a form is accessed, from the time the user begins/enters the form. If the form was not submitted prior to the time limit, the form would close and capture answers up to that point. We want to use this feature for interview assessments sent out to candidates. It allows us to…
