-
:% Completion Drop Down freeze
We are unable to use the drop-down option to update the % completion of our projects but it allows us to manually update it. It has being like this for about a week. How do I fix it?
-
Admin Control/Push Font Across Workspace/s
I would like to control and update the font for all sheets in every workspace. For example, I would like to change all data in workspaces/sheets to be Verdana 10. Right now we have different fonts across sheets. Then allow Contional Formatting be the only way for fonts to be altered. As admin can we have control over this…
-
RGYB Ball Color not showing on report intermittently
I have a report that pulls a summary row from various smartsheets. I have a column in these sheets titled Progress Indicator. I have a nested IF statement to show the correct ball color. I just noticed that some of the sheets are pulling in the actual ball symbol and some are giving me the text name of the color. When I go…
-
Duplicate Conditional Formatting in New Columns
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…
-
Conditional formatting based on Cell History
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
-
Conditional Statements
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…
-
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?
