-
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!
-
Formulas
I have two cases where I need a formula to work for me The first one is easy. I have two columns - Delivery Date and Delivery Date (2). I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell. I tried =[Delivery Date]1 but I get an error that says #number expected.…
-
Setting a project due date, then building tasks with predecessors leading into it - not working righ
I know there is a way to do this but for some reason I am stuck. I have an event taking place on 5/25. So that needs to be the due date and it CAN NOT MOVE. I then have maybe 40 or so tasks leading up to it, all of which have to occur in certain sequences. I am not able to set up the project. One of two problems occurs.…
-
Project Management: Notices to be sent out to clients
Good day, I have ongoing jobs with my clients that require deadline notifications of 3-year renewals, annual and quarterly requests along with reminders. I use Smartsheet as a checklist with the various dates and when to start processing these reports. The issue that I am having is that my clients do not wish to log in…
