-
How can I get the Summarize function in report to use a standard unit?
I am writing a report, and the base data gives % of a person's effort. For some reason, when I sum the totals for a category, some of the groups give a whole number, and others give a % value. In fact, it would be great to sum to a whole number, like the row for Total and the row for Sponsored, since 100% indeed equals 1.0…
-
Change default date format for the organization
The current default date format is MM/DD/YYYY for all sheets in Smartsheet. Many people in our organization dislike this format and opt to change the date format for individual sheets they are working on to be in a different format, such as DD/MM/YYYY or YYYY-MM-DD. The issue is that when different departments and teams…
-
Allow editable formatting in automated emails
It would be great if similar to a document generator, we could generate an email template. One example I have attached where it shows "1 row added or updated (shown in yellow)." It would be great if that was an option to enable or disable some of the email elements or have my own format filled out with information in my…
-
User-Created Dashboard Color Schemes
Our team would find it immensely useful to build a dashboard theme (choosing font face, font size, colors) from scratch. We strive for cohesive branding on things we build and being able to change the entire look and feel of a dashboard with just a few clicks would save us a lot of time.
-
Can you adjust the date/time stamp location on PDF export?
When I export a report to PDF, the date/time stamp populates in the lower left corner. Is there any way to adjust the settings to have the date/time stamp appear in the top right corner instead?
-
Automated Notification - Force Cell Reference Values to Wrap Text
Is there a way to make a cell reference in an automated notification show as wrapped text? I am trying to get the cell reference in the automated notification to show each selection on its own line. As shown in SmartSheet with Wrap Text on column. As shown in the Automated Notification cell reference.
-
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…
