-
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…
-
Receive an emailed attachment on submission of form.
Im creating a shipping request sheet and have created a form so people can submit address details etc . Once submitted this will go to a department for approval. I would also like an attachment to be sent with the email . For example, the email goes to the shipping department for approval and a standard packing list is…
-
Can the selections from a dropdown multi-select question in a form be used to auto create columns?
If I have a question in a project intake form that allows for individuals to multi-select all of the rooms that will be a part of a project can I then in turn use those selections to automatically create columns in the worksheet that corresponds to the rooms that were selected? Thank you for taking the time and any…
-
Button to add text to pictures is missing in Android app
Hi, According to the following help article there should be a button to add text to pictures when uploading pictures with the Android app. This button is missing in the app on my phone and on my tablet. I updated both devices to Version 9.3.0 Build 323. Is it possible to solve this? Screenshot from the article: Screenshot…
-
Add Form to project Dashboard in blueprint?
i want to avoid access to sheets entirely if at all possible to reduce chance of people changing formatting or columns or formulas. so im setting up reports and forms for everything in my blueprint. however i realized that the form added to individual project dashboards to submit RAID's does not update once project is…
-
Help with Update Request
I am asking leaders to fill out a form for promotion nominations with 3-5 contacts/emails for stakeholder feedback. My hope was to automate a request to each contact once the leader had submitted the form. Each stakeholder would get an update asking for: a yes/no on support, reasons to promote, and blockers to promote.…
-
Transfer data from one sheet to another
I know SS has the "move to another sheet" or "copy to another sheet" but sadly it does not look like you can do that and have "cell links" from the blank form that you are going to copy data to , to do other items. Does anyone do any copy / pasting that is advanced and would have some suggestions? Here is what I am doing…
-
depanedant dropdown list in smartsheet forms
Hi all, as discussed here https://community.smartsheet.com/discussion/38196/dependant-dropdown-lists I am looking for the ability to have an depandant dropdown list in smartsheets forms. e.g. if the employee select his company only the associated departments should be shown to be selected. By the way, appsheet…
-
Sheet Summary CountIFS + Date Range
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
"Unexpected Error"
Hi All, One of my colleagues has been experiencing an issue with approval workflows. When she goes to submit it she keeps getting "An unexpected error has occurred". I checked to make sure she is using Google Chrome and she is a fully licensed account. It happens to her so often that it holds up other workflows because she…
