-
Hiding Completed Projects in Task Report
Good morning, I'm creating seperate reports for each of my users which pulls in all of their tasks. I'd like to remove or hide the tasks that have a '100%' listed in the '% Completed' column. I've added the '% Completed' column to my report and set up the 'What?' to exclude anything in which the '% Completed' cells contain…
-
Formula Help Error Message NETWORKDAYS
New user of SmartSheet and not too adept at Excel. I am trying to make a formula IF/AND so that there is no error message in a cell that uses the NETWORKDAYS functions if there are not dates in the two source columns. E.g., Job Complete-Est and Job Complete-Actual only have a date in neither or one So, if there is not a…
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
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…
