Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Conditional formatting based on the current date?
Hi, I'd like to highlight tasks (specifically the Start date cell) a color when that date is less than the current date (today) and Completion is 0% or null. In other words, which tasks were supposed to start but have not yet started. I realize this is a complex condition that uses two fields but it would be helpful as a…
Insert Row: Automatically Links Cells
I am trying to figure out a way to best organize my project tracking... For example, my company has four big projects coming up, let's call them projects A-D. We have organized our sheets by project, and then created various sections within the sheet for each team working on the project, with sub-sections for task…
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
Adding system columns in the confirmation email?
Hi, I have two system columns: an auto generated number to represent order number and a created on timestamp. When I create the web form, I want these two fields to be added into the confirmation email so that when a user submits the form, they can see their order number as well as the timestamp. Is that at all possible?…
Calendar view , extend tasks to show duration over multiple days
It would be great to be able to see the DURATION of tasks in Calendar view. At the moment you can just see the task start date! See attached example
Make a row dissapear from a sheet
Very basic question, I have a list of jobs in a Sheets. is it possible to make the row dissapear if I mark that row as done using a drop down list. I know longer need the row info in my sheets and I want to keep my sheets down to a managable size.
Item being migrated to a new Smartsheet server?
We are getting this error message on one particular smartsheet: Is anybody else having the same problem? Can somebody in Support contact me to resolve it? Its been going on for a few hours and is rather inconvenient!
real examples and projects
Hi, Are there real examples or projects that are built on smartsheet ? Thank you
Removing Resources
Novice question, I'm sure. Building a project plan, i had added "placeholder" users until the roles were filled by actual people. Now that I no longer need the placeholders, how do I go about removing resources from the list to eliminate clutter? Thanks in advance for any help with this.
Losing workspace shares
I am having a recurrent probem with sharing workspaces with colleagues - it seems that the shares are set up properly, and work for a while (usually about 10 minutes) and then everything reverts back to the previous arrangment. Any suggestions? Graham
