-
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.
-
Formatting issue with my rowID field, anyone notice anything like this before?
I've used this same formula in a few sheets now. In the past it's looked like the first screenshot below. Using the same formula in any new sheet I create it's now putting the expected values for the second line on a third line below the "-", seen in the second screenshot. Here's my formula: =Account@row + "- " + [Story…
-
Negative Number Formatting in Parenthesis
As a Smartsheet user, I want a standard numbering format to display negative numbers in parenthesis with proper thousands/millions/etc. commas and currency symbols, in order to visually display negative numbers in more of an accounting style rather than the standard negative symbol. I've had multiple colleagues ask if…
-
Merged: Format text/characters within an individual cell
This discussion has been merged.
-
Is there a way to apply conditional formatting in Dashboards?
Is there a way to apply conditional formatting in dashboards? Specifically looking to apply conditional formatting to pie charts. For example, I’d like anything between 10 and 19 to appear in red, and anything between 20 and 24 in green.
-
Formatting Sheet Summary Reports
Enable formatting in sheet summary reports. E.g changing text size, bolding, colour, move value to centre etc. Currently sheet summary reports look sloppy, requiring time consuming work to add the values as metrics to dashboards if you want them to be presented well.
-
Formatting in board view: headers and dividers
I have a use case where I need users to update existing information and there are a lot of columns. It would be great if I could have the same functionality from Forms in and open card or board, like adding lines or text blocks (with formatting options) to break up different sections, adding or removing certain fields,…
-
Merged: Time Format for Column
This discussion has been merged.
-
PDF Fillable form loses fillable fields after it is generated through Smartsheet
We created a fillable form using Adobe Acrobat and use that as the mapping for our workflow automation to generate a document. We require a digital signature after the PDF is generated, but the digital signature option on the form does not copy over through the generating of the PDF. The formatting has copied over in the…
-
10 Auto Rows Automatically Have Green Cell in Status Column In Smartsheets
Hi! We have 10 blank rows on our orders page in Smartsheets. Those 10 rows have a cell under our Status column that is automatically highlighting green. I've checked conditional formatting and don't see anything out of the ordinary. I've looked for hidden columns, but don't see any. I've tried to manually clear the rows,…