-
Formating date columns per person, per preference
We are an international organization and having the dates in a single format on one sheet for everyone is not customer friendly. Is there a way to customize the dates by the column (have multiple columns with different formats - mm/dd/yyyy; yyyy/dd/mm; dd/mm/yyyy) specifically, we would prefer to have it spelled out (April…
-
Line breaks for widget titles
As far as I can see, there's no way to add a line break for title widgets, or other widgets (like reports or charts). When there is a particularly long title, my team has to manually adjust the size of the widget box. It would be nice for formatting purposes to hit Alt + Enter to create a line break for titles :) It has…
-
Merged: Ability to Add Line Breaks to Titles & Widgets
This discussion has been merged.
-
Why is the Date function not working?
I want to calculate the first day of a month based on the "created date" column. I tried using Year Function to get the year, then the Month to get the month and last column calculates =Date(([Yearcolumn]@row),([Monthcolumn]@row),1) Yet I get the #INVALID COLUMN VALUE year and month formulas are set on number format What I…
-
Merged: Remove Formatting Option on Report View
This discussion has been merged.
-
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.