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",…
Is there a way to make "Send me a copy of my responses" mandatory/a required field?
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.
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
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…
我有一个表单,要求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".…
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…
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
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.
