-
forms and empty sheet rows except for the ID (Locked primary column)
We have a form to support entry of data for requests. Occasionally I have found several empty rows except for the ID field in our sheet, and I would like to understand why that happens so I can educate my team.
-
Viewers and Forms
With the new roles and model rolling out, could someone tell me if a viewer only person can still fill out a form from withing Smartsheet? Meaning, when a form is created for a sheet, it appears under the sheet in the Workspace panel. Can they use the form there, or do I need to post an external link?
-
Give the option for Shortcut Widgets to open link in same tab or new tab
Currently shortcut widgets operate differently depending on if you are opening a Smartsheet item or an external link. Smartsheet items open in the same tab. External links open in a new tab. You can have the option for Smartsheet items to open in a new tab by just linking it as external, but you have no option to open…
-
Help with cross-sheet references
I am having some trouble understanding this. I have a form connected to a large gathering sheet where individual peoples info is all tracked by a 'Unit' or team. I have automations set up to separate each units info from the form to that individual unit (So I have one form collecting 25ish teams form info, and then it gets…
-
Date Logic in Form
In forms it is not uncommon to have a Start and End date for any reason (mine is for PTO). It would be very helpful if there could be some logic added to Date fields to compare with other Date fields. In my case I need to add logic that prevents a user from entering an End Date that is prior to the Start Date. Today this…
-
Can we modify character limit on a question (field text/number) to be less than 4000?
-
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…