Can titles of columns be rotated so more can be squeezed into view?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
I am trying to set a colored dot to Green if the project is on time, Red if it is late and Yellow if it is not started ([Date Completed] = blank). The Red and Green work, but I cannot get the yellow dot. Any help would be greatly appreciated. This is the formula as it stands. =IF(OR(ISBLANK([Date Completed]1, "Yellow"),…
Hi there, Does anyone know how to pin shortcuts for specific Smartsheet files to Google Chrome? Essentially, I'm after the quickest way (minimum number of clicks) to open specific Smartsheet files. Thanks, Paul
Hi there, We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given project to gain approval.…
A PICK Chart is a very effective Lean Six Sigma tool used to categorize process improvement ideas https://www.vertex42.com/ExcelTemplates/PICK-chart.html I am still a newbie using Smartsheet -- is there a template or can SS be created to match the example "Action Item List with PICK Ranking" shown in the above URL (near…
Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects. Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt schedule options (of…
I have a project plan that was created by importing a plan from Project. I would like to create a report that shows the resources and their utilization on a single day. The only filter I see in the Report Builder is to filter on the Start Date or the End Date of a task. I want to see anyone who has tasks that occur on a…
I am trying to figure out how to write a formula to auto assign a task when it meets different criteria. For example, my column is "Type of Request". If it is Creative, then I want to assign Kristi from my contact list. If it is Product, I want to assign John. I have 7 different choices within the Type of Request column…
I would like to use the dropdown list of contacts in a web-form, does anyone know if this is possible? thanks Adam