-
Header Formatting for Formulas
How do you convert the first row to mirror the header row? The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we type in the header name, we receive error messages as if the sheet cannot find the information. We are thinking that there is a…
-
Formatting Fix
There currently isn't a way to keep the format from other apps in Smartsheet. As a workaround, I paste data as plain text, using Ctrl+Shift+V or right clicking and choosing "Paste as plain text". It would be really nice if we were allowed to paste directly and keep the format from other apps such as Word Doc, Excel, or…
-
Multiple selection dropdown formatting in Metric Widget
Hi all! As of now, when using a Metric Widget in a dashboard that pulls from a multi select dropdown field, the values appear like this (see image), a blue-ish/cyan color as a background. It would be great to be able to customize the colors or even better, from a consistency perspective, to have the formatting pulled from…
-
Change Background Color for Multiselect Columns in Metric Widget
Hi there! I'm pretty new to Smartsheet, so wondering about an (apparently) missing feature. I'm aware that in Sheets, multiselect columns options appear in a grey background. The challenge I'm experiencing is that when pulling those values into a dashboard via a Metric Widget, those values appear with a blue-ish/cyan…
-
Merged: Table format in forms
This discussion has been merged.
-
Using full stops or commas for numbers
***Translated via Google Translate by a Moderator as the Community is currently only supported in English*** Good morning, I have a problem regarding the random use of commas or periods when entering numbers in a smartsheet form. In the Italian version, in fact, if you use a point instead of a comma, the cell is no longer…
-
How to change date format in generated document
I am having trouble with the date reporting out as mm/dd/yyyy when I would like it reported as dd-Mmm-yyyy. I have a created date column, and a second column with function =DATEONLY([Created Date]@row), and the column is formatted as dd-Mmm-yyyy, as shown in the screen shot below. When I go to generate a document with this…
-
Dynamic View - Description AND Comments Rich Text Formatting
Being able to format the information in the description pane and Comments. At the moment anything more than 100~200 words is very difficult to follow. Bold/Italic/Underline Hyperlink Ordered/Unordered lists Basically, the same formatting options available when posting an idea in this forum.
-
Form Date Format defaults to MM/DD/YYYY even though Form is set to DD/MM/YYYY
Hi all I searched the topics and other questions but could not find a satisfactory answer. I am in the UK and have set my setting to DD/MM/YYYY but I'm using a US licence (global company) On the sheet, a date column is formatted to DD/MM/YYYY - when I open the form from the link, the date is DD/MM/YYYY but I can't change…
-
Merged: Formatting within a Report
This discussion has been merged.