-
Extract text from one cell to populate the assignee cell in a Smartsheet recognizable contact?
I have a challenge i have been racking my brain on for a while. I want to extract names from my ACTION ITEM cell that will update the ASSIGNMENT correctly instead of just a text string. I am using the =MID, FIND ":", LENS, FIND ":" to extract & populate the HELPER COLUMN, but then want to make sure that the ASSIGNEE will…
-
How to write VLOOKUP to source data from multiple sheets
I have a Master Project sheet and multiple individual project sheets. I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet. While VLOOKUP will work, the wizard requires me to know the sheet that I want to search. I need to reference all sheets in a workspace as the…
-
Move all tasks to new column, not just Parent cards!
I primarily work in card view, running the project via Scrum methodology. When I move level 1 cards into the 'done' column, it doesnt move the level 2 subtasks into 'done' as well. This is an expected outcome for Smartsheets, but I'd argue that when working in card view, you would only move parent card into 'done' when all…
-
Inactivate a task
Is there a way to make a task or group of tasks inactive in a project plan? In Microsoft Project there's a function called Inactivate that's used after you select tasks that you want to make inactive. Doing this does not affect resource availability, the project schedule, or how other tasks are scheduled. I know this…
-
Tracking hours spent on a task
We need to track the actual time spent on each task (daily and/or weekly) in addition to the percentage completed (gantt) . Any ideas how I can configure that?
-
How can I
I'm trying to find a way of updating the column Term Expiration Date with the New Term Date column. I currently have a workflow that once a date is entered into the New Term Date it copies that row to a new sheet. The problem that I am running into is if I use the Data Mesh, or Data Shuffle it tends to update…
-
Assigning numeric values to drop down menu options
I want to assign a unique numeric value to each of the options in a drop down menu column, and have that numeric value display in an adjacent cell. Drop down menu options in each cell are: Needs Contributor Contributor Reviewing Ready for Production If 'Needs Contributor,' is chosen, then adjacent cell is populated '1' If…
-
Batch uploading to drawing register
We use smartsheet for our drawing registers but are having to upload each drawing individually. Is there a way to upload drawings in batches and each one automatically upload to a different row. It is very long winded at the moment the way we are doing it, especially when then having to input the relevant drawing numbers…
-
Creative Project Management - Help Streamline
Hi everyone, I’m a Creative Program Manager working closely with designers, the studio team, and cross-functional teams to ensure projects are released on time. Right now, we use Smartsheet in a very basic way—just a grid with dates. I think my current sheet has too much information and I'd love to streamline. I’d love to…
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.