-
Conditional lock
Hello, I am trying to develop a shareable sheet in which some tasks are listed along a row and check boxes are used to indicate a task has been completed. Would it be possible to lock these checkboxes if its previous one haven't been checked? In this way a process flow would be enforced. Perhaps the solution would include…
-
Rotate Text?
Can titles of columns be rotated so more can be squeezed into view?
-
Master build schedule to sync with other sheets?
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…
-
IF(OR(ISBLANK) Statement
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"),…
-
Smartsheet file shorcuts
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
-
How do I get around approvers being on vacation in a workflow?
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.…
-
PICK CHART and Smartsheet Template
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…
-
Resourcing is looking at SCC template gantts
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…
-
Report on Resource Utilization on a Single Day
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…
-
Auto Assign w/in Marketing Request Tracker
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…
