-
Feature request: Column for tracking time automatically
Smartsheet should add a standard column. Initally it includes a button syaing "start". When pressured on, a clock starts running in the background and keeps on running until one press the same button ( displaying the accumulated time for the task) or until the same user press another "start" button in the same or any other…
-
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.