-
Formatting in Formula Cells
I have two date cells that I have formatted as long dates (May 30, 2018) titled Contract_Begin and Contract_End. I want the formula cell to read contract begin date through contract end date (for ex: May 30, 2024 through August 10, 2024). However, the cell formats to 5/30/24 through 8/10/24. I posted the formula I am using…
-
Text Wrap Not Working in Primary Column
The primary column of my sheets are not wrapping text. I have turned it on and off, saving and reloading between each toggle, and verified that all of the reports into which the sheet feeds have wrapping properly applied. It is a problem on sheets I have created from scratch, those from templates, and ones that were shared…
-
European Date Format - Only working visually?
Hi, I have two columns in my sheet that are set as dates, though many of them are formulas that derive in dates based on variables such as, [If date 1 = X and task 1 takes 3 days, DATE = Date 1 + task duration = X+3] and so on. I have the date columns formatted in Day/Month/Year: however it only seems to impact the…
-
Negative Number Formatting in Parenthesis
As a Smartsheet user, I want a standard numbering format to display negative numbers in parenthesis with proper thousands/millions/etc. commas and currency symbols, in order to visually display negative numbers in more of an accounting style rather than the standard negative symbol. I've had multiple colleagues ask if…
-
Inconsistent Cell Formatting
Hello, Why does the orientation of values in a cell reset every time I open a sheet, regardless of whether I have saved it or not? I have to continually make the same adjustment to columns to have the values show aligned right or aligned center etc. The sheets look very sloppy. What is going on here?
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Phone Numbers and Street Addresses turn to Blue Font but only on Phone App
Hello, We have an interesting issue where all the phone numbers and street addresses we enter in a given row turn to blue font, but ONLY if viewing on the phone app. No matter what we do, we cannot figure out how to override this. It's an issue because a large majority of our conditional formatting relies on the use of…
-
Why doesn't the date format change for certain columns?
Hi, I am trying to change the date format (to 01-Jan-2024) of 4 columns. I could apply the change to 3 columns, but not the forth one ("Project Sheet end date"). The cells are linked to a sheet and the date format is also 01-Jan-2024 in the source sheet. Why isn't the format being applied to the forth column?
-
Exporting Smartsheet into Excel and Rendering Checkboxes
Can Smartsheet do something on their end so that checkboxes "checked" in Smartsheet don't render as "TRUE" after exporting the sheet into Excel?
-
Generate Document Text Customization
When generating documents, there is a preset text and text size. There are no options to customize. Often, the preset text does not match the text format on the document.
