-
Comments/note/document that attaches to the workbook?
I'm not sure how to describe this: Does Smartsheet offer any kind of a comments/note/document that attaches itself to the workbook, instead of a specific row? Here's why I ask: I would like a "How to use this sheet" document (standard work) that explains what the sheet is, best practices for how the team should use it, a…
-
I want my editors to view the Gantt chart
I want my editors to view the Gantt chart but when they try it says "as an editor or viewer on this sheet, you can not show the Gantt until it has been set up by the sheet owner (Admin). How so I do that so my team can view the calendar or Gantt chart? Thank you,
-
Repeating rows based on one cell value
I am try to go from a proposal to a detail sheet for our business. We make doors and you can have from 1 to about 100 or more of one type of door. On the proposal it is only shown as one line with a quantity cell. Now what I want to do it link that to a detail sheet, the sheet that will go to production, and list those…
-
Holidays over multiple projects
Hello, Is there anyway to default dependences so that when you start a new project sheet the dependences are already set? I am currently setting up multiple projects and having to enter working weeks, hours per day and holidays is quite time consuming.
-
Attaching Sheets to Sheets?
I'm using SmartSheets for residential construction project management. I would like to be able to attach a material takeoff sheets to rows where a material list is needed. Once done we could manage budgets and cashflow, as well as verify correct amounts, in the office by consolidating the material take off sheets on a…
-
Formulas lost when moving rows within sheets
I keep an 'active projects' sheet, and move projects to an 'inactive' sheet to keep the clutter down. The formulas do not move with the rows though, which is annoying (sometimes projects come back to the 'active' sheet when new samples come in, and I am now having to copy and pasting formulas into those cells). Any…
-
Formula Assistance
I’m sure I’m not the first to ask this. I could not find a post addressing my question. I am creating a sheet to track invoices through a department; receive to payment. I created a check box column titled 'January - Invoice Received' when the check box is checked i want the next column over titled 'January - Invoice…
-
Recurring Tasks and Allocation - for example part-time day off allocation
How do I set up a recurring task for the year? I have resources who are either booked 1 day a week on a specific recurring task, or who work part-time (e.g. 4 day week) and therefore have a 20% booking per week which is allocated to leave. How do i manage this? I've checked the "Team Vacation Schedule" template and I…
-
Printing Smartsheet
A few features that would be great when printing your smartsheet. ( 1 ) Option to print or include legend for Symbol Type Columns ( 2 ) Allow selectiong of Font Size in the Print Set Up window. Font sizes that look great on screen may not be great or are too small for report printing.
-
Formula Help
Community - Please help reduce this formula. My IT guy did it in 5 mins, and he said its crap, but it works. However, I now have to put it on ALL my projects and its too cumbersome. I didn't even try to do the formula.....I am too busy Here you go...and Happy Friday!! Louise=Amount6 - (IF(ISBLANK([Date Payment…