-
Dropdown Menu fonts conflicting with cell background
Hello! When a drop down value is used where light font is chosen, it renders the font within the drop down option unreadable because smartsheet applies a light background color to the down values themselves. See below. Work around is to clone each conditional formatting rule to apply darker font to certain columns, but…
-
Merged: Report Widget Content Formatting Options
This discussion has been merged.
-
How can I get a new row to populate with the format and formulas of the row above it?
The rows will be children of a same group. I am trying to make a simple checkbook style sheet and I want users to be able to add rows and have the all the formulas and formatting iterate down. From the above screenshot, I want the yellow fields to be added and the formula that subtracts the amount paid (yellow cells) from…
-
Merged: Cell Borders
This discussion has been merged.
-
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…
-
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…