-
Limiting Characters in a Cell/Date Validation
I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we want to limit them to no more than 25 characters, based on limitations from another…
-
Can you make a form be active for only a specific time period and then expire?
I'm looking to create a form that is only available for a 30 minute time period, after which, the form is no longer accessible to the people. Is this possible?
-
Error when adding more than 5 logic rules
I'm trying to add rules to a form with logic. I had 5 rules added but when I try to add a 6th, i get the error "logic statement is too large. try reducing conditions for the affected fields." Is there a limit to the number of rules I can add to a form?
-
Webinar recording available: Collaboration Best Practices
Missed the webinar? Review the recording in the Learning Center. Drive collaboration and transparency across your teams and organization, allowing everyone to work together to achieve more. In this webinar, we’ll share the many ways to collaborate using Smartsheet: Share sheets, reports, and dashboards Intake information…
-
Blank Rows
We have a simple ticket tracking sheet. It consists of a couple dozen columns and one form. It don't use any hierarchy, so all rows are at same level. There are several columns that use formulas - some cross sheet vlookups, some date calculations, turnaround time, etc. Nothing too complicated, however, the formulas in…
-
Including row comments with a form
I want to send a form as a regular update request but need to include the row level comments. However I can't see how to attach comments when using the form builder.
-
Can I auto assign multiple users in a form?!
I have a form that auto assigns when a new record is created. The sheet allows multiple contacts to be assigned - however, I can only select 1 in the "default" value.... :(
-
Dynamic Default Date
I am trying to set up a default date within a form field to always be today's date + 5 days. For example, I am creating a marketing asset request form. I would like the review date field to default to a 5 day turnaround time, with the option for the requestor to modify the date if needed. Is there a way to do this?
-
Forms within a Sheet
I was hoping to know if it is possible to have a form as a popup? Currently I have checkable flags associated with a risk. I was wondering if it is possible for a form to popup for additional information when one of my team members checks the flag to reflect that there is a risk.
-
Form sheet that gets cell linked to another summary sheet
I have a sheet that gets fed numbers from a form. The form will get filled out daily. I thought I had it all figured out-- I had the form add the newest entry row at the top and I linked those cells to my summary sheet. But then I realized that there was no way to make the linked cell link to an absolute row value, it…