Good night how can I sort the rows of a date column from my spreadsheet? I am using filters so I can't use the "classify rows" function. Is there any formula for columns to always be sorted by date order? thank you!
It would really be amazing in a future release to be able to do conditional formatting for alerts and notifications. I find myself managing the statuses of my tasks more than I should. Any ideas on if this might make it in the next release?
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…
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?