-
Sheet Compare to highlight differences
The ability to compare sheets that have a similar layout and list differences between them. I know using Control Center and Global Updates to rollout projects and project changes will solve this issue but I have current/legacy projects that were manually created. It would be awesome if I could compare sheets in an attempt…
-
More than two horizontal scroll??
I am finding that 'freezing' a column is only allowing one freeze = 2 horizontal scrolls. Is there any way to create more opportunities to scroll batches of columns?
-
I have a blank sheet that i want to populate with only the column values from another that contain X
Hello I have a fresh blank sheet, and another data sheet that for example contains the Columns: Fruits, Fruit price/kg, Inventory, etc I want to in my new blank sheet have a Fruit column that only includes the ones with string "apple" so data sheet may contain: Pineapple, green apple, red apple, AND, Orange, Banana,…
-
Currency formatting in calendar app
Currently, the calendar app does not pull over the formatting from cells. For example, one of the column I have displayed in my calendar is a budget number However, in calendar view the currency isn't formatted correctly. So for right now, I have to manually add formatting to every project we have which is incredibly…
-
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.
