-
What controls the formatting of sheet names in a report?
I want to get them all consistent. I don't care if it's a really weird workaround and not a built-in feature - is there ANY way to edit whatever they are based on? Do they adopt the formatting of a particular cell or something? Thank you.
-
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.
-
Template Formatting For Graphs - Consistent Colors
Is there a way to keep the colors consistent for graphs. For example, I created a graph showing units by color, with columns. Right next to it, I created a pie chart using the same source data but the colors for each unit represented are different. I know I can change them to match, but what a pain to do this for all my…
-
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?
