-
Formula help
Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
Cell level independence (type)
Hi, Will we see a cell level independence concept soon in SmartSheet ? Currently, we can defined entire row functions and column types but cells are bound by these row and column settings (can't be overwritten) Ex: An entire row can be commented on but no a specific cell. What if we have a column specific data set and want…
-
Using Web Form to Update different sheets
I am using Smart Sheets as a work order tracking tool for multiple properties. I would like to use one standard web form with either a drop down list or check box of properties. When a user selects the property they need service, the sheet attached to the property would be updated. One web form with direction to update…
-
Printing gant view
I'm trying to print a gantt chart with the columns that are displayed plus the timeline. The system is only printing my primary column and the timeline bars. I see no settings to adjust this either by printing straight out of the sheet or by creating a report. Anybody have any ideas?
-
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.