-
Dependency Settings
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
-
Historical Report Status
I am looking to increase my efficiency when creating statistical reports. Each week, we run a report to see how our projects are tracking (red, yellow, green traffic lights) but I what I want to do is keep each weeks statistics so that I can create a historical report of these figures. At the moment, each week I need to…
-
Feature Request: Toggle on/off a Report Builder search parameter
What I would like to be able to do is toggle on/off search parameters in the Report Builder for a given report. I have a report which I use daily. There is a search parameter I which I want to be able to activate and de-active to get a certain view of the report. For example, I embed a keyword/tag in the Primary column…
-
Linking within Sheet
I know you can use = to link cells within a sheet, but if I needed to link an entire row, is there a way to do that? Or even a couple cells at a time? I tried highlighting all of the cells I need to link & doing a bulk edit sort of thing, but that didn't work. Wanted to ask before I spent an hour linking a million cells…
-
creating formula to add many non-adjacent cells
I need to sum/add many (~120) non adjacent cells. They are all in a single column. When I create a formula and start clicking in the cells to include, I keep being returned to the bottom of the sheet where the formula is calculated. Then I have to scroll back up to the top of the sheet to access the next cell I want to…
-
Recuring events
Hi there, Is there a way to schedule recuring events in the timeline without having to insert new individual tasks? This would be for recuring site meetings etc. Thanks Annina
-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
Resource View: % allocated bar
Hey team. When I look at my resource view, both within the project, as well as in the Resource View area, the colored bar is not over Mon-Fri, but over Tues-Sat. I have already changed my account settings to show that our work days are M-F. Ideas?
-
Assigning contact to multiple tasks
Is it possible to assign a contact to more than one task at the same time? I have a sheet with 65 rows - there are contacts with multple tasks so trying to avoid having to pick from the list on each single task. Thanks in advance for any help offered.
-
Multiple Projects in IT, each may impact the other. Is there a smartsheet for this?
We are a firm working on one project in IT. We understand, after interviewing people in many different departments that other projects will impact our project. How can we manage this using smartsheet? Is there a template available for impact/conflict? Thanks in advance!
