-
Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row? I've been prototyping SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card,…
-
COUNTIF between Dates (Children) || Summary
I have a formula that is troubling me. I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days). The forumla below is returning zero. Is it the forumnla or a setting? The screen cap below is the from the sheet I am using, hopfully it…
-
Form for a task list
New to this I am trying to create a form with task list on it for site. Screenshot below This will be viewed on a mobile phone. When I create a new form the information (tasks) on the sheet do not appear on the forms. I want the information to appear with the facility for a crew member to tick the box once the task has…
-
Web Content Widgets
Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?
-
Timeline Display Dates Before Project Start
Im new to SS. Does anyone know how to change the setting on the gantt timeline display to start the day of the project. I've played around with the primary and secondary headings but the timeline still prints before the project start date. Example: My project started on 12/30/15 but the timeline starts on 12/1/15.
-
Publish Calendar View
Is there way to publish the calendar view only? I am needing to share just a bit of data in a calendar view only without sharing the entire sheet. Thank you in advance for any help.
-
Setting character limits on SS Cells or form area
Does Smartsheet allow you to set a restriction on the amount of characters allowed within a cell or in the txt box within forms? Thank you
-
Sequential Numbers "IF"
I have a project management template that I am trying to set up with a column to produce sequential purchase order numbers only if a column named "ORDER DATE" is populated in specific category rows I have named "ORDER MATERIALS". Can this be done? I am not too good at formulas, so the more specific, the better for me in…
-
Enhancement Request: Auto-Refresh Functionality
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
-
Conditional Formatting Cell Level
Hi, I need help or guidance in Conditional Formatting at CELL Level not all rows or all columns. For example: if the % is Below 30 its RED, 30 - 80 its Yellow and 80 + is Green. Please see attached the photo for more clarification. Thanks and please help.
