-
Concatenate formula to combine Date and Time into unique code
When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format…
-
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…
-
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…
-
Merged: Allow editable formatting in automated emails
This discussion has been merged.
-
Merged: Formatting of cells in reports and dashboards
This discussion has been merged.
-
Square Radio Buttons?
Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows the radio buttons as squares. I don't know why they look this way. Has anyone had this issue and/or know how to fix it?
-
Dynamic View: Allow ALL Formatting Options
I've found multiple requests in this forum for Dynamic View formatting options. but none of them request what I am asking for below. This request covers almost all the other Dynamic View formatting feature requests I've found in this forum. The Request: In Dynamic View Settings, add a "Match Data Source Cell…
-
Dynamic View Row Height Formatting of Wrapped Text: Bug? Or How Do I Fix it?
We're moving to the new and "better" User Subscription Model soon. Because free users will no longer be able to modify data in cells, we're trying to create Dynamic Views for all our City's Workspaces where free users need to add/update data. The problem is that the automatic Row Height formatting does not work properly on…
-
Setting values from form to zero
I have a form for customer feedback with ratings 1-5 and an N/A option. I'd like to apply logic such that the N/A value is set to 0. So I can work with it in other columns with formulae, avg rating, etc.
-
Change Background Color of Dropdown Bubbles
Is there a way to change the background color of the dropdown bubbles? On the main report, everything is in its own gray dropdown bubble, which is best for black text. However, when I run a report, the dropdown bubble is removed, leaving the text over a background color that varies with our color coding. In this case,…