-
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…
-
Possible to insert today's date (dynamically) as Form default using URL Query String
Hello - I need to find a way to have a Date field default to the current date on a Form. (I can't use the systen-date field, as user needs to be able to override 'todays Date' if necessary) Unfortunately, selecting the obvious Date field-type default value to 'Today' .... locks in, literally, today's date - the date the…
-
Pre-populated form
I have two forms, one where an applicant fills out and it populates the smart sheet. Then as the users update columns, they need to send a 2nd form that is filled out to the applicant. I have the URL creating in a column and when the email goes to the applicant, all fields are populating correctly. However, when my staff…
