-
Is there a way to log the email of a person submitting a form without requiring them to Login?
I have a Risk & Issues tracker on a Smartsheet grid; For people to submit a new Item we have them submit a form, but some folk with edit access are able to bypass the form (And it's required fields) by manually adding new cells to the sheet. We were able to track these using the Created By column, if the email was…
-
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?
-
Merged: Give the option for Shortcut Widgets to open link in same tab or new tab
This discussion has been merged.
-
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…