-
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.
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Project Settings Options Not Providing Every Column as Option for % Complete Column
We have a Project Plan with dependencies anables and parent/child relationships across the plan. I want to show the % complete visually in the Gantt section where the thinner % complete ribbon overlays the task ribbon based on it's percent complete. However, when I go into Project Settings>Options>% Complete column, it…
-
Add a New Task with all the sub rows
I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
-
Batch Editing
I would love to be able to select multiple tasks on a sheet and change the status if they are all the same. This could affect dropdown columns and date columns.
-
contact
I started a Smartsheet trial yesterday. What I really need is to be able to SPEAK to someone personally about this application! There is no contact number available for "trial users". One found on Google does not work. And any email (3) that I was able to find was either unmonitored or no longer active! How can a…
-
I need to create a high level project on a detailed project that contains a number of indented rows
I have tried to create the high level project sheet using linked cells and the index function however it keeps failing to transfer the information across. I need the sheets linked so that when information is added to the detailed sheet it will update the high level sheet