-
Can Character limits be added to text fields, specifically for a form?
I saw the post from 6/18/21 here: https://community.smartsheet.com/discussion/80492/can-character-limits-be-added-to-text-fields However, the formula =IF(Text@row >= 50, "Limit Reached. Please use less characters") is creating an #UNPARSEABLE error.
-
Possible to send MS Outlook email Templates once a task is reached
I am trying to set up outbound emails to send to external parties for their deliverables, setting timelines, and forms to complete once certain milestones/tasks are reached with in a project. Is it possible to have a email template built / added and have that template pull in information from the sheet summary such as…
-
Schedule Form Deactivation & Friendly Form Ended Msg
Hello all, I've searched this topic but only found old ideas from 2019'ish, so I'm hoping there has been an update made to Smartsheet or someone found a better workaround (meaning user friendly) than what was previously suggested. 1) I'd like to schedule a form to deactivate at a set date/time. I'm not seeing that as an…
-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…
-
Enhancement Request: TODAY() as default value in forms
Hi team, I find that it would be very useful to the user just to implement a way to set up the date of "today" into data fields of Smartsheet Forms and new entries in Dynamic view. In essence it would take today's date as default value. Upvote if you find this useful so it could be implemented
-
Is it possible to build a system where a single form submission can dynamically create many tasks?
Typically, one submission of a form results in one row on the sheet the form belogs to. Is there a way to have one submission resulting in multiple rows (6-8) that assign work to different team members? Our customers purchase multiple ad products on a single insertion order. Ideally, Sales would complete one form, select…
-
Will moving Smartsheet with form break link to form?
If I created a Smartsheet with a form in an IT workspace, will it break the link to the form if I move it to another department's workspace?
-
How to Automate Email to the Submitter?
I'm trying to set up an automation that will email the submitter once their request has been set to a status called "Approved". I made a Contact list column for the submitter to enter their own email, but when testing this automation, the submitter never got an email. Any help with this would be greatly appreciated!
-
Form dropdown options pulled from another sheet
Hi! I would like to make a form with the options pulled from another sheet. This is to prevent an incorrect project code being entered. The column drop-down options would need to be a the list of project codes from another sheet. The drop-down options would need to update continually as new project codes are added to the…
-
Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.