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
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.…
Change the color of a Gantt bar dependent on a checkbox or other common status indicators.
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…
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…
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?
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?
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?
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?
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…
