-
Editing a date item is not in the same format as the column format
Hi, Most of the time I use a different date format than the standard US default. When I edit a cell that contains a date, it is converted first to the default format. This makes it difficult to make small adjustment manually because the day, month and year is in a different order than what I see all around. See this…
-
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,…
-
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.
-
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…