Good afternoon! Hoping someone has experienced this issue before. We have established a number of conditional formatting rules for 7 drop down selections in one column labeled Site "A". If we add a new column for Site "B" and Site "C", can those conditional formatting rules be copied from the Site "A" column without having…
Hi Is there a way to format a row - based on when a partcular Cell was modified rather then when anything in the row was modified? In this example I would like to format the row based on how may days the Client has been at a particular status Thanks Lee
Hi Everyone, I would like to as add formula to the start date and finish date of the task/project like, if the duration is less than 3days, the result will "rush fee applies" like a note. And, another formula is for language services or any other; language checks box yes or no if I click on yes those languages will appear…
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 %…
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…
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…
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
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…
