-
Formula trouble with IF or IFS
I have a sheet being used as a project schedule in which I want to auto-indicate the project lifecycle stage in a cell on the sheet's meta-data line. To do so, I envisioned using an IF AND statement or something similar. Below is a mock up of the way it might look in excel. Project Lifecycle Phase = XXXXXX COLUMN B C Row %…
-
removing check boxes from a row
Hi all - this seems like it would be easy but I cant figure it out. I have a spreadsheet with different sections, most rows I DO want the check boxes but on my header rows which are separateing my sectinos I DO NOT want the check boxes but I can't figure out how to get rid of them since they are a column property. Anyone…
-
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an…
-
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
-
Help! classify by date
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!
-
Conditional Formatting for Alerts/Notifications
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?
-
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.