-
Formula Auto populate
Hi, I am facing a challenge..when I submit a new form the formula is not auto populated in that row..Please advice. moreever, I am using a IF error formula this does not show blank like its does in Excel IFERROR(IF(VLOOKUP([ES_Code]1, {Lookup Sheet Range 1}, 7, 0) = [Audit fees are denominated in this currency]1, "Yes",…
-
Mandatory Fields
Is there a way to make "Send me a copy of my responses" mandatory/a required field?
-
Is it possible to hyperlink text in a form.
This would allow the user to access additional information when completing the form. I have placed a link to some information in another sheet but the link is long. I know there are applications that shorten urls but I would prefer to hyperlink the text.
-
Alerts for sheets with web forms
Hi everyone I was wondering if there is a way to set up an alert when a sheet is approaching the limit of entries. ( data is coming in thorough web forms) Thanks! Noemi
-
Convert multiple text dates to a date field in a single cell
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential order throughout the form entry. I am looking to see if it’s possible to take multiple text dates entered in a single cell and…
-
Can I have the default value be a function?
I have a form that asks for someone's name. Most of the time, the form is for that person. There are some cases where a person might fill out the form on behalf of someone else. What I'd like to do is have a "name" field and a "on behalf of" field. If "on behalf of" is blank, I'd like it to default to the value of "name".…
-
Web forms, is it better to add at top or bottom
I have been using web forms to populate existing sheets with new data. But I have a question as to whether it is better to have new data at the top of the sheet or the bottom? 1. I see that updates are referenced by row number, so if I have data come in and an update request is sent out. And then new data is added at the…
-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian
-
Create a Form with dynamic fields
Hi, There is a way where we can create a form and in this form we can duplicate a set of field as much as we need? Currently, I am calling a form and at the submission, I am redirecting to another form, and on submission, I am redirecting to the same report. Could we have this in 1 form only? Thank you.