-
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
-
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
-
Changing to Office 365 login
Good morning, We now have Office 365 for some of our licensees/users. How can I integrate my current Smartsheet account under my old email address with our new O365 email? FYI that I do have the Smartsheet app for O365 Outlook installed and am already using it. Blessings, Loann
-
Making % Complete Column Accurately Reflect Work Done
Hello, I am looking for a way to make the % complete on my parent rows reflect only work that takes effort, rather than processes that are just elapsed time. For background, my group uses smartsheet for project management purposes, but we also use it for billing. Our parent rows in our project sheets are all billing…
-
Enterprise video?
Good morning, I did a search in the online videos on demand, but didn't find one. I'm looking for a video that gives a fairly in-depth look at what the Enterprise features are and how this is of greater benefit. Our IT dept is concerned that they would need to be our go-to for help regarding Smartsheet, and I'd like to…
-
Smartsheet (Beta) for Office 365
Good morning, I'm loving this feature in Outlook! It's always there, so if a new assignment is sent I can simply add it to SS from the email. Sweet! In clicking on a sheet name for an existing entry I notice it only goes to the sheet and not the row. Is this on the future enhancements list, by chance? It would be a great…
-
Project Initiation form in SS?
Everyone, I would like to use SS to provide a central point for business units to entering new project requests. Wondering if anybody has used SS for that purpose and with what results. Is SS right fit for that? Maybe it's not. Thanjs
-
Advanced Cell Linking Capabilities?
When we list our monthly marketing promotions (what's new, what's on sale, what's exclusive) in our Marketing Master Plan, we link those cells to other sheets where it would be useful to have that data on hand (for copywriting, graphics design, email plan, etc). Only problem is that if something gets added at last minute…
-
Is it possible to apply conditional formatting to reports?
My current understanding of reports is that each row replicates the formatting from whatever sheet it pulls from. Is it possible to create conditional formatting rules within the report itself?
-
Subtask Dependencies Error Message "REF"
I am getting a "REF" message in the subtask cell for Predecessor column. For example: Line 3 Start SF, start date: 8/18/15; end date: 8/18/15 = I entered the number 2 Line 4 Update SF, start date: 8/19/15; end date:9/17/15 = I entered the number 3 Line 5 Review SF, start date: 8/19/15; end date: 9/16/15 = I entered the…