-
Count column that is blank and another column that is not blank
I am trying to do a formula to count how many files are not yet audited: where my "closed/referred date" column is not blank, but the "audited" column is blank. Ive looked at other examples, but keep getting unpareseable errors any help would be greatly appreciated
-
How do I (as admin) get notified if someone changes/adds content in Dynamic View?
How can I get email notifications if someone changes/adds content in Dynamic View? Are there settings for this in DV or in the source sheet? Thanks!
-
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…
