-
Checklist
I work at a construction company that installs windows/doors for residential homes. We currently us a checklist in our current system. The checklist is use by both installers in the field as well as office team members. Any suggestions on how I can incorporate a similar checklist in Smartsheet?
-
PDF link in dashboard
It would be nice that a PDF can be dragged and posted to the dashboard. thanks!
-
Why don't I see the critical path?
Hello Community, I have predecessors and dependencies, but I don't really see a critical, summary or driving path even though I have clicked to show them. Can anyone tell me why? Thanks, Ashley
-
Add project name to update requests
I have numerous projects that all have the same work breakdown structure. If I send out request updates (via automation) the end user doesn't know which project the request is asking about. Unless I specifically state what project I am referring to in a manual update request I don't see a way to have that info included. So…
-
UTC Date Fix - Response Required
I've not been active on this site over the past 2 weeks or more, simply because I'm becoming increasingly frustrated with the limitations I'm faced with because of bugs, oversights and a lack of fundamental features. Primary for me is a fix to the UTC Server vs Local date issue. I've spent time trying to get around it with…
-
Project Status Report > Horizontal View
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
Smartsheet Calendar - Removing Completed Tasks from the View
Hello, I have been investigating the capabilities of Smartsheet Calendar and was most interested in how to use it to track multiple projects through a Smartsheet Report. The report I've created pulls from several projects, all containing a "Completed" column with checkboxes to mark status for tasks. In setting up a…
-
RYGG ball and task status formula based on % complete and due date
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
-
Shortcut & Hyperlink accessible to Non Smartsheet users
Creating Dashboard, Sheet to centralized all links to other sheet in a Workspace. I need non Smartsheet user to easily navigate from sheet to sheet to collect data from them. My tasks: Creating Workspace out of a template. Publish sheet Insert hyperlink to freshly created sheet/Dashboard Share Master sheet to non…