-
commas after each choice in a multi select row
Hello, I have a helper row where I want all the selections FROM A MULTIPLE SELECTION column to appear. I got it to work, but I would like a comma separating the selections. What I'm exactly trying to do is combine all the selections in the Multi-Select "SPECIALTY" column PLUS the single item in the "SUB-SPECIALTY" column.…
-
Do links/formulas update in the background without opening the sheet?
Ive built a project management system in SCC and have setup everyone to work from reports. If all goes well no one would ever go into a sheet. If no one goes into the sheets ever, would the formulas and cell links and conditional formatting, etc update still? or do these require someone to enter a sheet (not a report) and…
-
Form Text Color Customization?
Does anyone know if there is any way to get the description text/font in a form with a picture to stay white? During the Engage conference, they presented the new form customizations, and it has an image with white text, but I can’t find any options to modify the text color in the settings. Any guidance you can find is…
-
Force a format in a cell
We have a form that requires a 10 digit phone number. Clients are not entering the full number, is there a way to have Smartsheet make sure that 10 digits are entered in that cell? Thank you, Stephanie
-
Web Form: Multiple Similar Entries
Hello, When more than a handful of similar entries (with minor variations) have to be submitted via web form, is there a way to have the form keep the previous data so that it can be submitted without the submitter having to retype every field over and over again? Thank you, Ok Hee
-
Smartsheet forms with text formatting
Hello. Is there an option to allow text formatting/editing (such as bullet points, bolding, italics, hyperlinks) in a form linked to a smartsheet? I have a column in a sheet named description, which I would like users to give a comprehensive description using the Form. Ideally similar to the formatting options I see within…
-
Restricting Text/Number Columns to a Format
Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful to have, especially with the amount of forms that I, along with my Smartsheet…
-
Form - Require fields in specific text formatting
I hope there's a way to do this, as it's frustrating with the limitations, but is there a way to make a Text or Contact List field on a form, require to be entered into a specific format? For example, I need the user to enter a valid email address, but both the Contact List and Text fields allow any garbage text to be…
-
Report Issue
I have created a report that pulls info from 5 different sheets, and have set the report to group by the project column. All projects are being grouped correctly, except 1. The Coding Rewrite project is displaying each row individually. Interestingly, when I change the group setting to group by Sheet name, it displays…
-
Summary Report
We have created a grouping in a report. As per requirement, we grouped by date, but we need to remove/hide the highlighted information from the sheet. We have tried in the way Grouping by the column type "Month, Year" , but through that it is grouped by month name alphabetically so not fulfil my requirements.