-
Applying formula/conditional formatting to an entire column + hiding the column
Hi all, I am using the LEN formula in one column ("EN title character count") to show the number of characters in another (column "EN title") then applying conditional formatting to this column ("EN title") to show as bolded and red when the character count is greater than 80. This works perfectly, but I'd like to be able…
-
Dependencies help
Hi, When I create dependencies , is it gonna change the status for me automatically?If not how to do it easliy? NAME STATUS task a in process task b in process task c waiting(dependent)...TASK C is dependent on task B task d to do (no dependencies) task e to do (no dependencies) When i'm done with task b, I will change the…
-
calendar view
My project management has a sheet for scheduled work. We have a color associated with each job according to who the technician is do it. Is there a way to add patterns to the lines as well to determine who is managing the job too?
-
webforms
I use a web form which creates a code in the actual smartsheet, is there anyway of sending that code back to the person who raised the webform?
-
Auto-numbering defect tracking
I am using Smartsheet with several vendors who are testing and comparing legacy solution with new product. I have a checkbox column setup to identify potential defects. Can I have a column that only auto-numbers on a condition that a defect has been identified?
-
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
-
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Shade every other row in Grid View
How do I make my grid view smartsheet to automatically shade every other row a different color background so it's easier to read?
-
Why no Parent() object in Formulas?
I would like to default a value in child row based on a column value in the parent row. Meta-Code: IF Parent()[Column Name]='valueX' THEN Child()[Column Name]='valueX' Can someone walk me through the syntax for that?