Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for November 2017
Discussion List
Gantt Chart Due Date Flag / Milestone
Hi, Is it possible to show a 'flag / milestone' as well as the duration bar on one line of data. I would like to have a due date associated with a task, as well as a duration. Such that I can see instantly how close I am to a due date. Thanks
Please move "Refresh" to the toolbar, and give me a keyboard shortcut.
I would really like to see "Refresh" added to the toolbar. I think a lot of other people would too. Synchronizing changes with other collaborators in near-real-time relies on hitting refresh repeatedly. It's hidden behind a drop-down. Getting new users to refresh (or save) consistently as a matter of best practice has it's…
Reminders in templates
Good morning, When I create a template the reminders do not transfer. Am I doing something wrong? The reminders are in the original sheet that I use to create the template. Thank you! Susana
How to analyse/illustrate slippage of tasks in Smartsheet
Hi, I would like to get my sheets to highlight tasks which are overdue for completion in Smartsheet, and any subsequent tasks which may slip as a result. I imagine I will need to do a formula for this would be grateful for any advice on how to do this. Thanks
Project Management Best Practice Ideas?
Good Morning Smartsheet Community! Does anyone have any best practices / suggestions they could share for multi-project management ideas? We are currently using a Report that pulls rows from the "Assigned To" column across all project sheets in specific workspaces; However, while it serves the purpose, it isnt visually…
Project Management - IF(OR(AND())) - Formula Help
I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my section, while also tracking the progress of tasks within each project, for both current and historical projects. I have…
Return "pending" if project lands between two dates
Hello, hoping for some help from the Smartsheet experts. I am looking to return "in progress" if a project lands between a project start date and project finish date. My start date, finish date and status are in 3 columns, side by side. Looking to automate the status column, to reflect in progress, when falling between 2…
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
Has anyone used Tempus by Prosymmetry?
My Smartsheet contact had recommended Prosymmetry to me for my companies resourcing and time tracking needs, and I'm doing due diligence and vetting. Can't find much information on this company including their seed funding or VC info. Has anyone else used this tool? What has your experience been?
IF(AND..........also ISDATE combo help please
Hi Team, I'm attempting to build a formula that requires three parts (I Think). The attachment below demonstrates in simple terms. When the production manager enters the date ("90 Day Defects Period") and clicks on the drop list ("PRODUCTION Job Status" and choose ("DEFECTS 90") the 90 days period will kick in. I want to…