-
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…
-
Can I auto-tab to a new field in forms when scanning barcodes
I am attempting to use barcode 128 with a control code to tab into the next field. When I scan the barcodes I am being pushed out into the address bar, instead of the next field. I've tried the Codes for Horizontal Tab, Vertical Tab, Line Feed and Form Feed. Is there a special code for smartsheet? I'm not super savvy, but…
-
Forms, field logic
I want to set up a field with a yes/no answer and with the following logic: if answered "yes" then show the fields d,f,g (i want these as required fields); and if the answer is "no", show the same fields d,f,g but as optional to answer. So the same fields are showed regardless of the answer, but depending on the answer the…
