-
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…
-
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already…
-
Expanding a line and losing any lines beneath it.
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
-
DATEONLY Formula Error Message
I cannot get my DATEONLY formula to work. It keeps giving me "missing or invalid parameters" as the result. I am trying to create a formula that gives me a date variance between Planned Start and Actual Start. My two column names are Planned Start and Start and I am trying to start in row 5. This is the formula I have and…
-
Resource location dependency
Hi, Is it possible to constrain resources based on location? Maybe have a dependency or something that would allow me to schedule only North East resources on projects located in the North East. If none are available, I'd be able to override this dependancy as well. Thanks!
