-
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
-
Desperate for help with a formula
I need help with a formula. I want to look at a revised date and the original due date, and have the value that is greater in another column for formatting purposes. Here is what I am using. =IF(([Revised Due Date]734 - [Due Date]734)>0, [Revised Due Date]734, [Due Date]734). Can someone help me ? Thanks, Sharon
-
Conditional Formatting, enhancement requests
Some features I would like to see in the future: 1. Allow using a formula for conditional tests. Using only the drop-downs is rather limiting. e.g. If COUNT(CHILDREN())>0 then apply... 2. Allow selecting multiple columns to apply formatting. It's super annoying to clone a rule several times to highlight multiple columns.…
-
Enhancement Request - Conditional Formatting on Gantt Bars
Change the color of a Gantt bar dependent on a checkbox or other common status indicators.
-
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?
